How to select variables and values in StatBank

Table content

The first choice are the available statistic variables. All tables in StatBank have at least one statistic variable. Click to highlight one or more values.

Classification variables

There are also one or more boxes, each representing a classification variable. The available values are listed in the boxes. If, for instance, you want the figure for a specific municipality, highlight this in the list box with the variable name “Region”.

Show table

When you hvae marked all the values that you want for your table, click "Continue". Here you also can see how many cells there will be in your table. 

How do I select values?

There are a variety of ways you can select more than one statistic value from a variable:

Several individual values
Hold the Ctrl key in while clicking on the required values.

Several consecutive lines

• First, click on one value, then keep the Shift key pressed while clicking on another value.
• Or – click on a value and then left click on the mouse while moving the cursor up/down.

Select all values
Click on the “v” icon to highlight all values in the box.

Remove all selected values
Click on the “–” icon to remove all the highlighted values in the list box.

How do I change the size of list boxes?

Hold the cursor over the two triangles between two list boxes. The cursor is now a double arrow. Click and drag to the left/right to change the width of the list boxes.

How do I get the total figure for a variable?

For some variables, if you don’t select any values you will be given a total figure.

If you have selected one or more values and want to remove these in order to get a total figure, use the '–' icon.

You must always select at least one value from the time variable.

How do I change groupings of variables?

For some variables it is best to have groupings of values, such as for the variable “Region”. The values here can be grouped as “Municipalities”, “Counties”, “Whole country” or others. These variables always have a pulldown menu above the list box.

If you change this from, for instance, “Municipalities” to “Counties”, the content in the list box is replaced with values for the counties. You cannot select municipality and county in the same operation. If you require the figure for Norway as a whole, select “The whole country” from the pulldown menu. The values in the list box are then changed. Select “0…Whole country” in this list box.

Where can I find more information on definitions and standards?

 

You will sometimes notice that variable headings are clickable. These are links to variable definitions (Vardok) or classification standards (Klass). The variable ”Region” contains, for example, Statistics Norway’s standard classifications for municipalities and counties, as well as ways of organising municipalities through what are known as correspondence tables.

 How do I use “Select via groups”?

This function is used for variables that have groupings. You can either select individual values for the group’s content or totals of individual values.

How do I search for large valuesets?

Click on magnifier icon to search in long and extensive lists.

 The fast solution here is to select all available values.