# GetHyperCubePivotData method

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

Information note

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

## 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) |

## Returns

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

## See also

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

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