On this page

Columns

The cols parameter defines the visualization's hypercube . The number of columns you need to specify depends on the visualization. If you specify too few columns, you will get an Incomplete visualization error, just as if you created it in the client.

The order of the columns are in some cases not important. For a basic bar chart with one dimension and one measure, the columns can be specified in any order. However, for a table it does matter in which order the columns are specified. The order you specify in the cols parameter is the order that will be shown in the table.

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 dataset 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.

The full list of available options is documented in the Engine API documentation.

Using 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.