# CollapseLeftAsync Method

## Overloads

| [CollapseLeftAsync(String, Int32, Int32, Boolean)](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.GenericObject.CollapseLeftAsync.htm#Qlik_Engine_GenericObject_CollapseLeftAsync_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. |
| --- | --- | --- |
| [CollapseLeftAsync(AsyncHandle, String, Int32, Int32, Boolean)](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.GenericObject.CollapseLeftAsync.htm#Qlik_Engine_GenericObject_CollapseLeftAsync_Qlik_Engine_AsyncHandle_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.GenericObject.CollapseLeftAsync.htm) [](https://help.qlik.com/en-US/sense-developer/Subsystems/NetSDKAPIref/Content/Qlik.Engine.GenericObject.CollapseLeftAsync.htm)

## CollapseLeftAsync(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

```

          public Task CollapseLeftAsync([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). |

### Returns

| Type | Description |
| --- | --- |
| System.Threading.Tasks.Task |  |

### Implements

[IGenericObject.CollapseLeftAsync(String, Int32, Int32, Boolean)](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IGenericObject.CollapseLeftAsync.htm#Qlik_Engine_IGenericObject_CollapseLeftAsync_System_String_System_Int32_System_Int32_System_Boolean_)

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

## CollapseLeftAsync(AsyncHandle, 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

```

          public Task CollapseLeftAsync(AsyncHandle asyncHandle, [QixName("qPath")] string path, [QixName("qRow")] int row, [QixName("qCol")] int col, [QixName("qAll")] bool all)
    
  
```

### Parameters

| Type | Name | Description |
| --- | --- | --- |
| [AsyncHandle](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.AsyncHandle.htm) | asyncHandle | Handle to asynchronous method request |
| 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). |

### Returns

| Type | Description |
| --- | --- |
| System.Threading.Tasks.Task |  |

### Implements

[IGenericObject.CollapseLeftAsync(AsyncHandle, String, Int32, Int32, Boolean)](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IGenericObject.CollapseLeftAsync.htm#Qlik_Engine_IGenericObject_CollapseLeftAsync_Qlik_Engine_AsyncHandle_System_String_System_Int32_System_Int32_System_Boolean_)