GenericObject.SelectPivotCellsAsync Method (AsyncHandle, String, IEnumerable(NxSelectionCell), Boolean, Boolean)

GenericObjectSelectPivotCellsAsync Method (AsyncHandle, String, IEnumerableNxSelectionCell, Boolean, Boolean)

This method only applies to hypercubes that are not represented as straight tables. The parameter qMode in HyperCubeDef must be set either to P or K.

** Pivot table **

Makes selections in the top or left dimension cells of a pivot table or in the data matrix. Only expanded dimensions can be selected.

** Stacked table **

Makes selections in the left dimension cells of a stacked table or in the data matrix.

There is no top dimensions in a stacked table.

** Example of a pivot table **

In the representation above:

Namespace: Qlik.Engine
Assembly: Qlik.Engine (in Qlik.Engine.dll) Version: 2.1.0.0+Build:7.origin/release/ms13

Syntax

Copy

public Task<bool> SelectPivotCellsAsync(
	AsyncHandle asyncHandle,
	string path,
	IEnumerable<NxSelectionCell> selections,
	bool softLock = false,
	bool deselectOnlyOneSelected = false
)

Public Function SelectPivotCellsAsync ( 
	asyncHandle As AsyncHandle,
	path As String,
	selections As IEnumerable(Of NxSelectionCell),
	Optional softLock As Boolean = false,
	Optional deselectOnlyOneSelected As Boolean = false
) As Task(Of Boolean)

Parameters

asyncHandle: Type: Qlik.EngineAsyncHandle
Handle to asynchronous method request
path: Type: SystemString
Path to the definition of the object For example, /qHyperCubeDef. This parameter is mandatory.
selections: Type: System.Collections.GenericIEnumerableNxSelectionCell
Information about the selections to perform
softLock (Optional): Type: SystemBoolean
Set to true to ignore locks; in that case, locked fields can be selected. This parameter is optional.
deselectOnlyOneSelected (Optional): Type: SystemBoolean
Set this parameter to true to unselect the last single selected value. There must be only one selected value in the field. The default value is false.

Parameters

Return Value

Implements

Reference