# ExpandTopAsync Method

## Overloads

| [ExpandTopAsync(String, Int32, Int32, Boolean)](https://help.qlik.com/en-US/sense-developer/May2026/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IGenericObject.ExpandTopAsync.htm#Qlik_Engine_IGenericObject_ExpandTopAsync_System_String_System_Int32_System_Int32_System_Boolean_) |  | Expands the top 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. |
| --- | --- | --- |
| [ExpandTopAsync(AsyncHandle, String, Int32, Int32, Boolean)](https://help.qlik.com/en-US/sense-developer/May2026/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IGenericObject.ExpandTopAsync.htm#Qlik_Engine_IGenericObject_ExpandTopAsync_Qlik_Engine_AsyncHandle_System_String_System_Int32_System_Int32_System_Boolean_) |  | Expands the top 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.ExpandTopAsync.htm) [](https://help.qlik.com/en-US/sense-developer/Subsystems/NetSDKAPIref/Content/Qlik.Engine.IGenericObject.ExpandTopAsync.htm)

## ExpandTopAsync(String, Int32, Int32, Boolean)

Expands the top 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

```

          Task ExpandTopAsync([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 expanded.<br>For example, `/qHyperCubeDef` . |
| System.Int32 | row | Row index. The index is based on the top dimension indexes.<br>Indexing starts from 0. |
| System.Int32 | col | Column index in the data matrix.<br>Indexing starts from 0. |
| System.Boolean | all | If set to true, it expands 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 |  |

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

## ExpandTopAsync(AsyncHandle, String, Int32, Int32, Boolean)

Expands the top 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

```

          Task ExpandTopAsync(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/May2026/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 expanded.<br>For example, `/qHyperCubeDef` . |
| System.Int32 | row | Row index. The index is based on the top dimension indexes.<br>Indexing starts from 0. |
| System.Int32 | col | Column index in the data matrix.<br>Indexing starts from 0. |
| System.Boolean | all | If set to true, it expands 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 |  |