Home > Figures > StatLine database > Help with selecting data

Help with selecting data

The selection screen offers three options to select variables. These can be chosen by clicking on the three icons on the left of the screen.

(icoon) All selections. This is the default. In every tab you can select variables in the table. The active tab is dark blue. The variables are categorised in yellow folders. By clicking on a folder the contents are shown in the next column. In this way you can navigate through the variables in the table. To select and unselect items, tick or untick the boxes. Ticking the box in the dark blue bar will select or unselect all data in the column below.

When your data selection is complete, press the button 'show data' in the middle of the bar above and the table (or graph or map) will be shown. If you have not made a selection in a tab, a default selection will be shown.

(icoon) My selections. Shows only the selected variables. You can quickly see which table will be shown. If desired you can unselect variables.

(icoon) Regional selection. This is only available if the table has a regional classification. You can select regions by clicking on the map or selecting them in the dropdown boxes of the ‘Selection’ frame.

You can zoom by using the slider in the top left-hand corner. Click on ‘+’ to zoom in and ‘-’ to zoom out, or move the slider. Once you have zoomed in, an icon will appear under the slider which you can use to return to the original size of the map.

You can move the map by pressing the left mouse button while on the map. A hand icon will appear and you can move the map in the desired direction.

The option ‘minimap’ shows which part of the Netherlands is shown. By going to the selected box and pressing the left mouse button you can move the selected area.

The frame ‘Regions’ shows which regional classifications are available.

With the option ‘Year of regional classification’, you can select the regional classification belonging to a certain year. In the Netherlands names and borders of municipalities change nearly every year. Therefore the classification differs slightly from year to year.

Error messages

It is not always possible to show the all selected variables. If a table has more than 200 thousand cells, you be requested to change the selection. If a table has between 10 thousand and 200 thousand cells, it can be downloaded but not shown on screen. Also, a table with more than one thousand columns cannot be shown on screen.

There are even more restrictions for graphs:

A maximum of two subjects may be selected, and they must have the same unit;
The x-axis can contain at most 100 items;
The key can contain at most 10 items.

If these conditions are not satisfied, an error message will appear or the ‘Graph’ icon will become grey.

To create a map:

The table must have a regional dimension;
There must be a corresponding regional classification for every year; this is because regional classifications change almost every year because of restructuring;
No subject or dimension may have only empty cells

If these conditions are not satisfied, an error message will appear or the Map ‘icon’ will become grey.