Type Alias NxInlineMeasureDef

type NxInlineMeasureDef = {
    qAccumulate?: number;
    qActiveExpression?: number;
    qAggrFunc?: string;
    qBrutalSum?: boolean;
    qDef?: string;
    qDescription?: string;
    qExpressions?: string[];
    qGrouping?: NxGrpType;
    qLabel?: string;
    qLabelExpression?: string;
    qNumFormat?: FieldAttributes;
    qRelative?: boolean;
    qReverseSort?: boolean;
    qTags?: string[];
}
Index

Properties

qAccumulate?: number
  • 0 means no accumulation * 1 means full accumulation (each y-value accumulates all previous y-values of the expression) * ≥ 2 means accumulate as many steps as the qAccumulate value Default value is 0. This parameter is optional.
qActiveExpression?: number

Index of the active expression in a cyclic measure. The indexing starts from 0. The default value is 0. This parameter is optional.

qAggrFunc?: string

Flag indicating how the measure should be aggregated to create a grand total. "None" - No total calculation. "Expr" - Calculate total according to the measure expression. "" - Empty string is default and has same effect as "Expr". This parameter is optional.

qBrutalSum?: boolean

If set to true, the sum of rows total should be used rather than real expression total. This parameter is optional and applies to straight tables. Default value is false. If using the Qlik Sense interface, it means that the total mode is set to Expression Total .

qDef?: string

Definition of the expression in the measure. Example: Sum (OrderTotal) This parameter is mandatory.

qDescription?: string

Description of the measure. An empty string is returned as a default value. This parameter is optional.

qExpressions?: string[]

Array of expressions. This parameter is used in case of cyclic measures ( qGrouping is C). List of the expressions in the cyclic group.

qGrouping?: NxGrpType

Default value is no grouping. This parameter is optional.

One of:

  • N or GRP_NX_NONE
  • H or GRP_NX_HIEARCHY
  • C or GRP_NX_COLLECTION
qLabel?: string

Name of the measure. An empty string is returned as a default value. This parameter is optional.

qLabelExpression?: string

Label expression. This parameter is optional.

qNumFormat?: FieldAttributes

Format of the field. This parameter is optional.

qRelative?: boolean

If set to true, percentage values are returned instead of absolute numbers. Default value is false. This parameter is optional.

qReverseSort?: boolean

If set to true, it inverts the sort criteria in the field.

qTags?: string[]

Name connected to the measure that is used for search purposes. A measure can have several tags. This parameter is optional.