Skip to main content Skip to complementary content
Qlik Resources

NxStackedPivotCell

Properties

Name Description Type
qText Some text. String
qElemNo

Rank number of the value.

If set to -1, it means that the value is not an element number.

 Integer
qValue

Value of the cell.

Is set to NaN, if the value is not a number.

 Double precision floating point
qCanExpand

If set to true, it means that the cell can be expanded.

This parameter is not returned if it is set to false.

 Boolean
qCanCollapse

If set to true, it means that the cell can be collapsed.

This parameter is not returned if it is set to false.

 Boolean
qType Type of the cell.

One of:

  • V for NX_DIM_CELL_VALUE. Applies to values in the data matrix.
  • E for NX_DIM_CELL_EMPTY. Applies to empty cells in the top and left dimensions.
  • N for NX_DIM_CELL_NORMAL. Applies to left and top dimensions cells.
  • T for NX_DIM_CELL_TOTAL. Applies to cells marked with Total
  • P for NX_DIM_CELL_PSEUDO. Applies to pseudo dimensions.
  • R for NX_DIM_CELL_ROOT. Applies to root node.
  • U for NX_DIM_CELL_NULL. Applies to Null values in the data matrix.
qMaxPos Total of the positive values in the current group of cells. Double precision floating point
qMinNeg Total of the negative values in the current group of cells. Double precision floating point
qUp

Number of elements that are part of the previous tail.

 Integer
qDown

Number of elements that are part of the next tail.

 Integer
qRow

Row index in the data matrix.

The indexing starts from 0.

 Integer
qSubNodes

Information about sub nodes (or sub cells).

The array is empty [ ] when there is no sub nodes.

 Array of NxStackedPivotCell
qAttrExps Attribute expressions values.

Null or NxAttributeExpressionValues.

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!

Leave your feedback here