# ITreeDataDef Interface

Namespace: [Qlik.Engine](https://help.qlik.com/en-US/sense-developer/November2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.htm)  
Assembly: Qlik.Engine.dll

Defines the properties of a TreeData object.

For more information about the definition of a TreeData object, see `Generic object`.

## Syntax

```
[ValueClass]
public interface ITreeDataDef : IAbstractStructure
```

## Properties

| Name | Description |
| --- | --- |
| [CalcCondition](https://help.qlik.com/en-US/sense-developer/November2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.ITreeDataDef.CalcCondition.htm#Qlik_Engine_ITreeDataDef_CalcCondition) | Specifies a calculation condition object.<br><br>If CalcCondition.Cond is not fulfilled, the TreeData is excluded from the calculation and CalcCondition.Msg is evaluated.<br><br>By default, there is no calculation condition.<br><br>This property is optional.<br><br>JSON property name: qCalcCondition |
| [ContextSetExpression](https://help.qlik.com/en-US/sense-developer/November2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.ITreeDataDef.ContextSetExpression.htm#Qlik_Engine_ITreeDataDef_ContextSetExpression) | Set Expression valid for the whole cube. Used to limit computations to the set specified.<br><br>JSON property name: qContextSetExpression |
| [Dimensions](https://help.qlik.com/en-US/sense-developer/November2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.ITreeDataDef.Dimensions.htm#Qlik_Engine_ITreeDataDef_Dimensions) | Array of dimensions.<br><br>JSON property name: qDimensions |
| [ExpansionState](https://help.qlik.com/en-US/sense-developer/November2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.ITreeDataDef.ExpansionState.htm#Qlik_Engine_ITreeDataDef_ExpansionState) | Expansion state per dimension.<br><br>JSON property name: qExpansionState |
| [InitialDataFetch](https://help.qlik.com/en-US/sense-developer/November2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.ITreeDataDef.InitialDataFetch.htm#Qlik_Engine_ITreeDataDef_InitialDataFetch) | Initial data set.<br><br>This property is optional.<br><br>JSON property name: qInitialDataFetch |
| [InterColumnSortOrder](https://help.qlik.com/en-US/sense-developer/November2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.ITreeDataDef.InterColumnSortOrder.htm#Qlik_Engine_ITreeDataDef_InterColumnSortOrder) | Defines the order of the dimension levels/columns in the TreeData object.<br><br>Column numbers are separated by a comma.<br><br>Example: [1,0,2] means that the first level in the tree structure is dimension 1, followed by dimension 0 and dimension 2.<br><br>The default sort order is the order in which the dimensions and measures have been defined in the TreeDataDef.<br><br>JSON property name: qInterColumnSortOrder |
| [OpenFullyExpanded](https://help.qlik.com/en-US/sense-developer/November2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.ITreeDataDef.OpenFullyExpanded.htm#Qlik_Engine_ITreeDataDef_OpenFullyExpanded) | If this property is set to true, the cells are opened expanded. The default value is false.<br><br>JSON property name: qOpenFullyExpanded |
| [PopulateMissing](https://help.qlik.com/en-US/sense-developer/November2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.ITreeDataDef.PopulateMissing.htm#Qlik_Engine_ITreeDataDef_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.<br><br>The default value is false.<br><br>JSON property name: qPopulateMissing |
| [StateName](https://help.qlik.com/en-US/sense-developer/November2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.ITreeDataDef.StateName.htm#Qlik_Engine_ITreeDataDef_StateName) | Name of the alternate state.<br><br>Default is current selections `$` .<br><br>JSON property name: qStateName |
| [SuppressMissing](https://help.qlik.com/en-US/sense-developer/November2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.ITreeDataDef.SuppressMissing.htm#Qlik_Engine_ITreeDataDef_SuppressMissing) | Removes missing values.<br><br>JSON property name: qSuppressMissing |
| [SuppressZero](https://help.qlik.com/en-US/sense-developer/November2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.ITreeDataDef.SuppressZero.htm#Qlik_Engine_ITreeDataDef_SuppressZero) | Removes zero values.<br><br>JSON property name: qSuppressZero |
| [Title](https://help.qlik.com/en-US/sense-developer/November2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.ITreeDataDef.Title.htm#Qlik_Engine_ITreeDataDef_Title) | Title of the TreeData object, for example the title of a chart.<br><br>JSON property name: qTitle |
| [ValueExprs](https://help.qlik.com/en-US/sense-developer/November2025/Subsystems/NetSDKAPIref/Content/Qlik.Engine.ITreeDataDef.ValueExprs.htm#Qlik_Engine_ITreeDataDef_ValueExprs) | List of measures to calculate on the whole tree.<br><br>JSON property name: qValueExprs |