Skip to main content

qHyperCubeDef

ON THIS PAGE

qHyperCubeDef

Most visualization that comes 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

Engine API documentation for a complete description of the qHyperCubeDef properties.