# CollapseLeft Method

## Overloads

| [CollapseLeft(String, Int32, Int32, Boolean)](https://help.qlik.com/en-US/sense-developer/May2026/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IGenericObject.CollapseLeft.htm#Qlik_Engine_IGenericObject_CollapseLeft_System_String_System_Int32_System_Int32_System_Boolean_) |  | Collapses the left dimensions of a pivot table. This method applies only to pivot tables that are not always fully expanded.<br><br>In the definition of the hypercube (in `HyperCubeDef` ), the parameter `qAlwaysFullyExpanded` must be set to false. |
| --- | --- | --- |

[](https://help.qlik.com/en-US/sense-developer/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IGenericObject.CollapseLeft.htm) [](https://help.qlik.com/en-US/sense-developer/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IGenericObject.CollapseLeft.htm)

## CollapseLeft(String, Int32, Int32, Boolean)

Collapses the left dimensions of a pivot table. This method applies only to pivot tables that are not always fully expanded.

In the definition of the hypercube (in `HyperCubeDef` ), the parameter `qAlwaysFullyExpanded` must be set to false.

### Declaration

```

          void CollapseLeft([QixName("qPath")] string path, [QixName("qRow")] int row, [QixName("qCol")] int col, [QixName("qAll")] bool all)
    
  
```

### Parameters

| Type | Name | Description |
| --- | --- | --- |
| System.String | path | Path to the definition of the object to be collapsed.<br>For example, `/qHyperCubeDef` . |
| System.Int32 | row | Row index in the data matrix.<br>Indexing starts from 0. |
| System.Int32 | col | Column index. The index is based on the left dimension indexes.<br>Indexing starts from 0. |
| System.Boolean | all | If set to true, it collapses all cells.<br>Parameters `qRow` and `qCol` are not used if `qAll` is set to true, but they need to be set (for example to 0). |