# GetHyperCubeStackData method

Retrieves the values of a stacked pivot table. It is possible to retrieve specific pages of data.

Information note

This method works for a hypercube in DATA\_MODE\_PIVOT\_STACK.

## Parameters

| Name | Description | Mandatory | Type |
| --- | --- | --- | --- |
| qPath | Path to the definition of the object to be selected.<br>For example, */qHyperCubeDef* . | Yes | String |
| qPages | Array of pages to retrieve. | Yes | Array of [NxPage](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/EngineJSONAPI/Content/models-nxpage.htm) |
| qMaxNbrCells | Maximum number of cells at outer level.<br>The default value is 10 000. | No | Integer |

## Returns

| Name | Description | Type |
| --- | --- | --- |
| qDataPages | A data set. | Array of [NxStackPage](https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/EngineJSONAPI/Content/models-nxstackpage.htm) |

## See also

[Get the values of a stacked table](https://help.qlik.com/en-US/sense-developer/November2024/csh/engineapi/get-values-stacked-table)

[Sort by the values of a measure in a stacked pivot table](https://help.qlik.com/en-US/sense-developer/November2024/csh/engineapi/sort-by-values-of-measure-in-stacked-pivot)