What can I do with the table I created?
A number of tips on how to customise your table, how to save charts from the data and how to save the table or query for later use.
Rotating the table
Rotating a table enables you to change it around, for example by swapping the column headings and row headings.
Use these icons to rotate clockwise, anti-clockwise or rotate freely.
When rotating freely, you can use the arrow icons between the boxes to move the variables between the row headings and column headings. The arrow icons under the boxes can be used to sort the order of the variables.
You can can download the table in different formats, e.g. Excel. Relational table is the most pivot friendly format.
Save your query
When saving your query you get a link that you have to store yourself.
New September 2019: You can give an extension after the ID in the url. This changes the download format or link to your selections in the selection screen, e.g.:. https://www.ssb.no/en/sq/100000650?select
- .xlsx - Get result as Excel-file
- .xlsx_doublecolumn - Excel-file with double column
- .json_stat -JSON-stat-file
- .csv - commaseparated csv-file without heading
- .csv_semicolon - semicolonseparated csv-file without heading
- .csv_tabhead - tabseparated csv-file with heading
- .relational_table – matrix or relational table (txt)
- .html5_table – result as HTML5 table
- .px - result as PX-file
- ?select - shows your selctions on the selction screen
Removal of /en from the url gives the Norwegian version .If you change the saved query, you will get a new ID.
Saved query is not for automation. Users who run a lot of saved queries at release time, risk getting their IP blocked.
Editing the table
The options here are:
- Show the code and text.
Here you can remove rows with only zeros
The dropdown menu "Show table" also makes it possblie to present the table as various types of charts.
If you select a chart, "Table settings" changes to "Chart settings". Here you can set size, title etc.
API query for this table
The choice "API query for this table" gives JSON code and POST url for the extaction which is made. This can be reused in API: Create your own dataset.