Qlik Sense .NET SDK - API Reference
Qlik.Engine
IGenericObject Interface
IGenericObject Methods
AbortListObjectSearch Method
AbortListObjectSearchAsync Method
AcceptListObjectSearch Method
AcceptListObjectSearchAsync Method
ApplyPatches Method
ApplyPatchesAsync Method
BeginSelections Method
BeginSelectionsAsync Method
ClearSelections Method
ClearSelectionsAsync Method
ClearSoftPatches Method
ClearSoftPatchesAsync Method
CollapseLeft Method
CollapseLeftAsync Method
CollapseTop Method
CollapseTopAsync Method
CopyFrom Method
CopyFromAsync Method
CreateChild(T) Method
CreateChildAsync(T) Method
DefCount Method
DefCountAsync Method
DefPathAtIndex Method
DefPathAtIndexAsync Method
DestroyAllChildren Method
DestroyAllChildrenAsync Method
DestroyChild Method
DestroyChildAsync Method
DrillUp Method
DrillUpAsync Method
EmbedSnapshotObject Method
EmbedSnapshotObjectAsync Method
EndSelections Method
EndSelectionsAsync Method
ExpandLeft Method
ExpandLeftAsync Method
ExpandTop Method
ExpandTopAsync Method
ExportData Method
ExportDataAsync Method
GetChild Method
GetChildAsync Method
GetChildInfos Method
GetChildInfosAsync Method
GetFullPropertyTree Method
GetFullPropertyTreeAsync Method
GetHyperCubeData Method
GetHyperCubeDataAsync Method
GetHyperCubePivotData Method
GetHyperCubePivotDataAsync Method
GetHyperCubeReducedData Method
GetHyperCubeReducedDataAsync Method
GetHyperCubeStackData Method
GetHyperCubeStackDataAsync Method
GetInfo Method
GetInfoAsync Method
GetLayout Method
GetLayoutAsync Method
GetLinkedObjects Method
GetLinkedObjectsAsync Method
GetListObjectData Method
GetListObjectDataAsync Method
GetProperties Method
GetPropertiesAsync Method
GetSnapshotObject Method
GetSnapshotObjectAsync Method
IndexOfDefPath Method
IndexOfDefPathAsync Method
Lock Method
LockAsync Method
Publish Method
PublishAsync Method
RangeSelectHyperCubeValues Method
RangeSelectHyperCubeValuesAsync Method
ResetMadeSelections Method
ResetMadeSelectionsAsync Method
ResumeLayout Method
SearchListObjectFor Method
SearchListObjectForAsync Method
SelectHyperCubeCells Method
SelectHyperCubeCellsAsync Method
SelectHyperCubeValues Method
SelectHyperCubeValuesAsync Method
SelectListObjectAll Method
SelectListObjectAllAsync Method
SelectListObjectAlternative Method
SelectListObjectAlternativeAsync Method
SelectListObjectExcluded Method
SelectListObjectExcludedAsync Method
SelectListObjectPossible Method
SelectListObjectPossibleAsync Method
SelectListObjectValues Method
SelectListObjectValuesAsync Method
SelectPivotCells Method
SelectPivotCellsAsync Method
SetChildArrayOrder Method
SetChildArrayOrderAsync Method
SetFullPropertyTree Method
SetFullPropertyTreeAsync Method
SetProperties Method
SetPropertiesAsync Method
SuspendLayout Method
Unlock Method
UnlockAsync Method
UnPublish Method
UnPublishAsync Method
Click or drag to resize
IGenericObjectSelectPivotCells Method
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 **

Namespace: Qlik.Engine
Assembly: Qlik.Engine (in Qlik.Engine.dll) Version: 1.1.0.0 (1.1.0.0)
Syntax
Copy
bool SelectPivotCells(
	string path,
	IEnumerable<NxSelectionCell> selections,
	bool softLock = false,
	bool deselectOnlyOneSelected = false
)

Parameters

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.

Return Value

Type: Boolean
See Also