qHyperCubeDef

Most visualizations that come built-in with Qlik Sense are based on a hypercube definition (qHyperCubeDef) on root level. A hypercube can contain both dimensions and measures. If selections are applied to a hypercube, only the selected values are displayed.

You can have multiple hypercubes in your properties (initialProperties). This allows you to make advanced visualizations that combine several data sets. If you have multiple hypercubes, you need to place them at different paths in your property structure.

Examples

Example: Hypercube definition in Chart template

initialProperties: {
    version: 1.0,
    qHyperCubeDef: {
        qDimensions: [],
        qMeasures: [],
        qInitialDataFetch: [{
            qWidth: 2,
            qHeight: 50
        }]
    }
},

Example: Multiple hypercubes definition

initialProperties : {
        version : 1.0,
        qHyperCubeDef : {
            qDimensions : [],
            qMeasures : [],
            qInitialDataFetch : [{
                qWidth : 10,
                qHeight : 50
            }]
        },
        second : {
            qHyperCubeDef : {
                qDimensions : [],
                qMeasures : [],
                qInitialDataFetch : [{
                    qWidth : 10,
                    qHeight : 50
            }]
        }
    }
}

Example: Enabling numerical sorting

By defining qInterColumnSortOrder, numerical sorting on the measure is enabled. If you define qInterColumnSortOrder in initialProperties, you must also define the qDimensions and qMeasures being used, else an error will be thrown.

initialProperties : {
    qHyperCubeDef : {
        qDimensions : [{
            qDef : {
                qFieldDefs : ["Dim1"]
            }
        }
        ],
        qMeasures : [{
            qDef:{
                qDef : "=Sum(Expression1)"}
            }
        ],
        qInterColumnSortOrder : [1,0],
        qInitialDataFetch : [{
            qWidth : 10,
            qHeight : 50
        }]
    }
},

Properties

For a complete description of the qHyperCubeDef properties, see the Qlik Sense Engine API documentation

Learn more

Generic object in visualization extensions