Skip to main content Skip to complementary content

ExpandLeft method

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


Name Description Mandatory Type

Path to the definition of the object to be expanded. For example, /qHyperCubeDef .

Yes String

Row index in the data matrix to expand. Indexing starts from 0.

Yes Integer

Column index. The index is based on the left dimension indexes. Indexing starts from 0.

Yes Integer

If set to true, it expands 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).

Yes Boolean

See also

Collapse or expand the left dimensions of a pivot table

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!