CollapseLeft Method

Overloads

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

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

      public void CollapseLeft([QixName("qPath")] string path, [QixName("qRow")] int row, [QixName("qCol")] int col, [QixName("qAll")] bool all)

Type	Name	Description
System.String	path	Path to the definition of the object to be collapsed. For example, `/qHyperCubeDef` .
System.Int32	row	Row index in the data matrix. Indexing starts from 0.
System.Int32	col	Column index. The index is based on the left dimension indexes. Indexing starts from 0.
System.Boolean	all	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).

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!