Skip to main content Skip to complementary content

CollapseTop method

Overview

Collapses 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.

Parameters

Name Description Type
qPath

Path to the definition of the object to be collapsed

For example, /qHyperCubeDef.

This parameter is mandatory.

String
qRow

Row index. The index is based on the top dimension indexes.

Indexing starts from 0.

Integer
qCol

Column index in the data matrix.

Indexing starts from 0.

Integer
qAll

If set to true, it collapses all cells.

Parameters qRow and qCol are not used if qAll is set to true, but they need to be set (for example to 0).

Boolean

Outputs

The following is returned in the output:

"result": {}

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!