# TreeDataDef Class

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 TreeData object.

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

## Inheritance

* System.Object
  * [AbstractStructure](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.AbstractStructure.htm)
    * TreeDataDef

## Syntax

```
[ValueClass]
public class TreeDataDef : AbstractStructure, IDisposable, ITreeDataDef, IAbstractStructure
```

## Constructors

| Name | Description |
| --- | --- |
| [TreeDataDef()](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.TreeDataDef.-ctor.htm#Qlik_Engine_TreeDataDef__ctor) | Creates an instance of the TreeDataDef class |

## Properties

| Name | Description |
| --- | --- |
| [CalcCondition](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.TreeDataDef.CalcCondition.htm#Qlik_Engine_TreeDataDef_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/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.TreeDataDef.ContextSetExpression.htm#Qlik_Engine_TreeDataDef_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/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.TreeDataDef.Dimensions.htm#Qlik_Engine_TreeDataDef_Dimensions) | Array of dimensions.<br><br>JSON property name: qDimensions |
| [ExpansionState](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.TreeDataDef.ExpansionState.htm#Qlik_Engine_TreeDataDef_ExpansionState) | Expansion state per dimension.<br><br>JSON property name: qExpansionState |
| [InitialDataFetch](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.TreeDataDef.InitialDataFetch.htm#Qlik_Engine_TreeDataDef_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/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.TreeDataDef.InterColumnSortOrder.htm#Qlik_Engine_TreeDataDef_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/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.TreeDataDef.OpenFullyExpanded.htm#Qlik_Engine_TreeDataDef_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/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.TreeDataDef.PopulateMissing.htm#Qlik_Engine_TreeDataDef_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/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.TreeDataDef.StateName.htm#Qlik_Engine_TreeDataDef_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/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.TreeDataDef.SuppressMissing.htm#Qlik_Engine_TreeDataDef_SuppressMissing) | Removes missing values.<br><br>JSON property name: qSuppressMissing |
| [SuppressZero](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.TreeDataDef.SuppressZero.htm#Qlik_Engine_TreeDataDef_SuppressZero) | Removes zero values.<br><br>JSON property name: qSuppressZero |
| [Title](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.TreeDataDef.Title.htm#Qlik_Engine_TreeDataDef_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/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.TreeDataDef.ValueExprs.htm#Qlik_Engine_TreeDataDef_ValueExprs) | List of measures to calculate on the whole tree.<br><br>JSON property name: qValueExprs |