Query: How to create Column

Column: A collection of data presented in vertical columns (attributes), where the height of each cell is proportional to its scale.

Column Instructions - The sample chart uses the International Financial Statistics dataset and displays data for Germany's Producer Price Index from 2000 through 2005.

Users may follow the steps below to replicate the below chart. 

Select Stacked Column from View

Step 1: Select time
Step 2: Select country
Step 3: Select indicator
  • Click on the plus sign next to Fixed and select Indicator       
  • Place cursor over the Indicator attribute, and click on   
  • From the pop up dialogue, do a right click, go to Hierarchy and select Default.  Thereafter, do the following: 
  • Click on Prices, then
  • Click on Producer Prices, then
  • Select the following indicator: "Producer Price Index, All Commodities, Index".  Click Apply and OK. 

  • To quickly find an indicator, country or time period, use the provided search box. 
  • Place cursor over the 'play' icon to see the graph change over time or select each year separately to view it.
  • The system allows dragging and dropping variables between attributes (or by clicking on the wheel icon ) in the Data View pane for different results.

Help Documents and References

  1. Query: How to use it
  2. Search: How to use it?
  3. Export Data: How to Bulk Download
  4. Navigation: How to find a dataset from the Home page
  5. Query: How to find the indicator for which I want data?
  6. Query: How to select multiple indicators
  7. Query: How to select the countries for which I want data?
  8. Query: How to select time and frequencies for which I want data?
  9. Query: How to change the font and font size?
  10. Query: How to change the number of decimal places?
  11. Table: How to export data from Tables
  12. Query: How to change the units
  13. Query: How to export my Query table into Excel
  14. Query: How to save queries
  15. Query: How to retrieve longer historical data series for a dataset
  16. Search Tips
  17. Browser Compatibility
  18. Query: How to create a Pie chart
  19. Query: How to create a Rating chart
  20. Query: How to create a Table
  21. Query: How to create Stacked bar
  22. Query: How to create Stacked column
  23. Query: How to create Area
  24. Query: How to create Column
  25. Query: How to create Bar
  26. Query: How to create Line
  27. Query: How to create Spline
  28. Query: How to create Scatter chart
  29. Query: How to create Bubble chart
  30. Query: How to create Treemap
  31. Query: How to create Map
  32. Query: How to change database from the query tool
  33. How do I get the underlying data in a table or a chart?
  34. Finding Data using Concept Codes
  35. Data Services
  36. Using SDMX 2.0 Web Service
  37. Using SDMX 2.1 Web Service
  38. JSON RESTful Web Service
  40. EZProxy: How to configure on the User side
  41. Table: How to select countries for which I want data
  42. Table: How to select indicators for which I want data
  43. IFS publication in PDF file – where to find
  44. Composition of Current Statistical Groups and Aggregates
  45. Bulk Download: How to extract and view data in Excel?
  46. Data services: how to get the code of a dataset and a list of all dimensions and elements?
  47. Workbook: How to show additional attributes (Country Name, Indicator Name, Database, etc.)?
  48. Workbook: How to add an attribute (Country, Time, Frequency, etc.) to a Series Tree?

Feedback and Knowledge Base