157339
157339
friartikkel
2014-01-09T15:32:00.000Z
en

Help StatBank

What can I do with the table I created?

Published:

Updated:

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.

  show-table-selections

Rotating the table

Rotating a table enables you to change it around, for example by swapping the column headings and row headings.

roter-ikon

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. 

Save table

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. 

 Save query - steps

New September 2019: You can give an extension avter 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 the id in the link will also change. 

Editing the table

The options here are:

  • Show the code and text.
  • Sum
  • Percent

Table settings

Here you can remove rows with only zeros

Charts

The dropdown menu "Show table" also makes it possblie to present the table as various types of charts. 

Show table and 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.

Contact