# IHyperCubeDef Interface
Namespace: [Qlik.Engine](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.htm)
Assembly: Qlik.Engine.dll
Defines the properties of a hypercube.
For more information about the definition of a hypercube, see `Generic object`.
## Syntax
```
[ValueClass]
public interface IHyperCubeDef : IAbstractStructure
```
## Properties
| Name | Description |
| --- | --- |
| [AlwaysFullyExpanded](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IHyperCubeDef.AlwaysFullyExpanded.htm#Qlik_Engine_IHyperCubeDef_AlwaysFullyExpanded) | If this property is set to true, the cells are always expanded. It implies that it is not possible to collapse any cells.
The default value is false.
JSON property name: qAlwaysFullyExpanded |
| [CalcCond](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IHyperCubeDef.CalcCond.htm#Qlik_Engine_IHyperCubeDef_CalcCond) | Specifies a calculation condition, which must be fulfilled for the hypercube to be (re)calculated.
As long as the condition is not met, the engine does not perform a new calculation.
This property is optional. By default, there is no calculation condition.
JSON property name: qCalcCond |
| [CalcCondition](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IHyperCubeDef.CalcCondition.htm#Qlik_Engine_IHyperCubeDef_CalcCondition) | Specifies a calculation condition object.
If CalcCondition.Cond is not fulfilled, the hypercube is not calculated and CalcCondition.Msg is evaluated.
By default, there is no calculation condition.
This property is optional.
JSON property name: qCalcCondition |
| [ColumnOrder](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IHyperCubeDef.ColumnOrder.htm#Qlik_Engine_IHyperCubeDef_ColumnOrder) | The order of the columns.
JSON property name: qColumnOrder |
| [ContextSetExpression](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IHyperCubeDef.ContextSetExpression.htm#Qlik_Engine_IHyperCubeDef_ContextSetExpression) | Set Expression valid for the whole cube. Used to limit computations to the set specified.
JSON property name: qContextSetExpression |
| [Dimensions](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IHyperCubeDef.Dimensions.htm#Qlik_Engine_IHyperCubeDef_Dimensions) | Array of dimensions.
JSON property name: qDimensions |
| [DynamicScript](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IHyperCubeDef.DynamicScript.htm#Qlik_Engine_IHyperCubeDef_DynamicScript) | Hypercube Modifier Dynamic script string
JSON property name: qDynamicScript |
| [ExpansionState](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IHyperCubeDef.ExpansionState.htm#Qlik_Engine_IHyperCubeDef_ExpansionState) | Expansion state per dimension for pivot mode ( `qMode` is P).
JSON property name: qExpansionState |
| [IndentMode](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IHyperCubeDef.IndentMode.htm#Qlik_Engine_IHyperCubeDef_IndentMode) | This property applies for pivot tables and allows to change the layout of the table. An indentation is added to the beginning of each row.
The default value is false.
JSON property name: qIndentMode |
| [InitialDataFetch](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IHyperCubeDef.InitialDataFetch.htm#Qlik_Engine_IHyperCubeDef_InitialDataFetch) | Initial data set.
JSON property name: qInitialDataFetch |
| [InterColumnSortOrder](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IHyperCubeDef.InterColumnSortOrder.htm#Qlik_Engine_IHyperCubeDef_InterColumnSortOrder) | Defines the sort order of the columns in the hypercube.
Column numbers are separated by a comma.
Example: [1,0,2] means that the first column to be sorted should be the column 1, followed by the column 0 and the column 2.
The default sort order is the order in which the dimensions and measures have been defined in the hypercube. By default, the pseudo-dimension (if any) is the most to the right in the array.
The index of the pseudo-dimension (if any) is -1.
Pseudo dimensions only apply for pivot tables with more than one measure.
A pseudo dimension groups together the measures defined in a pivot table. You can neither collapse/expand a pseudo dimension nor make any selections in it.
Stacked pivot tables can only contain one measure.
JSON property name: qInterColumnSortOrder |
| [MaxStackedCells](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IHyperCubeDef.MaxStackedCells.htm#Qlik_Engine_IHyperCubeDef_MaxStackedCells) | Maximum number of cells for an initial data fetch (set in `qInitialDataFetch` ) when in stacked mode ( `qMode` is K).
The default value is 5000.
JSON property name: qMaxStackedCells |
| [Measures](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IHyperCubeDef.Measures.htm#Qlik_Engine_IHyperCubeDef_Measures) | Array of measures.
JSON property name: qMeasures |
| [Mode](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IHyperCubeDef.Mode.htm#Qlik_Engine_IHyperCubeDef_Mode) | Defines the way the data are handled internally by the engine.
Default value is `DATA_MODE_STRAIGHT` .
A pivot table can contain several dimensions and measures whereas a stacked pivot table can contain several dimensions but only one measure.
JSON property name: qMode |
| [NoOfLeftDims](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IHyperCubeDef.NoOfLeftDims.htm#Qlik_Engine_IHyperCubeDef_NoOfLeftDims) | Number of left dimensions.
Default value is -1. In that case, all dimensions are left dimensions.
Hidden dimensions (e.g. due to unfulfilled calc condition on dimension level) is still counted in this context.
The index related to each left dimension depends on the position of the pseudo dimension (if any).
For example, a pivot table with:
\* Four dimensions in the following order: Country, City, Product and Category.
\* One pseudo dimension in position 1 (the position is defined in `qInterColumnSortOrder` )
`qInterColumnSortOrder` is (0,-1,1,2,3).
\* Three left dimensions ( `qNoOfLeftDims` is set to 3).
implies that:
\* The index 0 corresponds to the left dimension Country.
\* The index 1 corresponds to the pseudo dimension.
\* The index 2 corresponds to the left dimension City.
\* Product and Category are top dimensions.
Another example:
\* Four dimensions in the following order: Country, City, Product and Category.
\* Three left dimensions ( `qNoOfLeftDims` is set to 3).
\* One pseudo dimension.
\* The property `qInterColumnSortOrder` is left empty.
Implies that:
\* The index 0 corresponds to the left dimension Country.
\* The index 1 corresponds to the left dimension City.
\* The index 2 corresponds to the left dimension Product.
\* Category is a top dimension.
\* The pseudo dimension is a top dimension.
JSON property name: qNoOfLeftDims |
| [PopulateMissing](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IHyperCubeDef.PopulateMissing.htm#Qlik_Engine_IHyperCubeDef_PopulateMissing) | If this property is set to true, the missing symbols (if any) are replaced by 0 if the value is a numeric and by an empty string if the value is a string.
The default value is false.
JSON property name: qPopulateMissing |
| [PseudoDimPos](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IHyperCubeDef.PseudoDimPos.htm#Qlik_Engine_IHyperCubeDef_PseudoDimPos) | JSON property name: qPseudoDimPos |
| [ReductionMode](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IHyperCubeDef.ReductionMode.htm#Qlik_Engine_IHyperCubeDef_ReductionMode) | JSON property name: qReductionMode |
| [ShowTotalsAbove](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IHyperCubeDef.ShowTotalsAbove.htm#Qlik_Engine_IHyperCubeDef_ShowTotalsAbove) | If set to true, the total (if any) is shown on the first row.
The default value is false.
JSON property name: qShowTotalsAbove |
| [SortbyYValue](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IHyperCubeDef.SortbyYValue.htm#Qlik_Engine_IHyperCubeDef_SortbyYValue) | To enable the sorting by ascending or descending order in the values of a measure.
This property applies to pivot tables and stacked pivot tables.
In the case of a pivot table, the measure or pseudo dimension should be defined as a top dimension. The sorting is restricted to the values of the first measure in a pivot table.
JSON property name: qSortbyYValue |
| [StateName](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IHyperCubeDef.StateName.htm#Qlik_Engine_IHyperCubeDef_StateName) | Name of the alternate state.
Default is current selections `$` .
JSON property name: qStateName |
| [SuppressMeasureTotals](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IHyperCubeDef.SuppressMeasureTotals.htm#Qlik_Engine_IHyperCubeDef_SuppressMeasureTotals) | If set to true, suppress any measure grand totals, ignoring any AggrFunc.
JSON property name: qSuppressMeasureTotals |
| [SuppressMissing](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IHyperCubeDef.SuppressMissing.htm#Qlik_Engine_IHyperCubeDef_SuppressMissing) | Removes missing values.
JSON property name: qSuppressMissing |
| [SuppressZero](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IHyperCubeDef.SuppressZero.htm#Qlik_Engine_IHyperCubeDef_SuppressZero) | Removes zero values.
JSON property name: qSuppressZero |
| [Title](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IHyperCubeDef.Title.htm#Qlik_Engine_IHyperCubeDef_Title) | Title of the hypercube, for example the title of a chart.
JSON property name: qTitle |