Skip to main content

Columns (dimensions and measures)

When using the Visualization API or the qlik-visual web-component, hypercubes are defined in the cols parameter. The number of columns needed to be specified vary depending on the visualization type. If too few columns are specified you will receive an incomplete visualization error just as if the visualization was created in the Qlik Sense client.

Overview

There are three different ways of specifying the columns:

The above three methods can be combined in the same create statement. You can use a simple string syntax for one column, a more advanced object for another and a predefined master measure for the third.

Note: The order of the columns are not always important. For a basic bar chart with one dimension and one measure, the columns can be specified in any order. But for a table it matters which order the columns are specified since the order specified in the cols parameter is the order shown in the table.

String syntax

If a string starts with =, it will be treated as a measure, otherwise it is treated as a dimension.

[ "Case Owner Group", "=Avg([Case Duration Time])" ]
Note: Using the string syntax is quite easy but at the same time there are some limitations. If you want to set labels or limit the data-set to only the top five values, you should use the object syntax instead.

Object syntax

Use the object syntax if you want to set more options for your columns. If you. for example, create a pivot table with labels, you should use qFieldLabels for dimensions and qLabel for measures.

[ /*dimension*/ "Year", /*dimension with label*/ { "qDef": { "qFieldDefs": ["Case Owner Group"], "qFieldLabels": ["Group"] } }, /*measure with label*/ { "qDef": { "qDef": "=Avg([Case Duration Time])", "qLabel": "Avg Case Duration Time" } }, /*measure with label*/ { "qDef": { "qDef": "Sum( [Open Cases] )", "qLabel": "Open Cases" } } ]

You can limit the data set to only show the top five values using qOtherTotalSpec.

[ { "qDef": { "qFieldDefs": ["Case Owner Group"], "qFieldLabels": ["Group"] }, "qOtherTotalSpec": { "qOtherMode": "OTHER_COUNTED", "qOtherCounted": "5" } } "=Avg([Case Duration Time])" ]

Referencing predefined dimensions and measures

You can use dimensions and measures that are predefined in the app. This is mostly relevant if the user should be able to select dimensions and measures from lists. You must know the Dimension ID or the Measure ID, which is defined in the qLibraryID property. You must also state if it is a measure or a dimension in the qType property.

[ { "qLibraryId":"eqZjE", "qType":"measure" } ]