Skip to main content Skip to complementary content
Qlik Resources

NxInlineMeasureDef

Properties

Name Description Type
qLabel

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

 String
qDescription

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

 String
qTags

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

 Array of String
qGrouping

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
 String
qDef

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

 String
qNumFormat

Sets the formatting of a field. The properties of qFieldAttributes and the formatting mechanism are described below.

Formatting mechanism

The formatting mechanism depends on the type set in qType, as shown below:

Information note

In case of inconsistencies between the type and the format pattern, the format pattern takes precedence over the type.

Type is DATE, TIME, TIMESTAMP or INTERVAL

The following applies:

  • If a format pattern is defined in qFmt , the formatting is as defined in qFmt .
  • If qFmt is empty, the formatting is defined by the number interpretation variables included at the top of the script ( TimeFormat , DateFormat , TimeStampFormat ).
  • The properties qDec , qThou , qnDec , qUseThou are not used.

Type is INTEGER

The following applies:

  • If a format pattern is defined in qFmt , the engine looks at the values set in qDec and qThou . If these properties are not defined, the formatting mechanism uses the number interpretation variables included at the top of the script ( DecimalSep and ThousandSep ).
  • If no format pattern is defined in qFmt , no formatting is applied. The properties qDec , qThou , qnDec , qUseThou and the number interpretation variables defined in the script are not used .

Type is REAL

The following applies:

  • If a format pattern is defined in qFmt , the engine looks at the values set in qDec and qThou . If these properties are not defined, the engine uses the number interpretation variables included at the top of the script ( DecimalSep and ThousandSep ).
  • If no format pattern is defined in qFmt , and if the value is almost an integer value (for example, 14,000012), the value is formatted as an integer. The properties qDec , qThou , qnDec , qUseThou are not used.
  • If no format pattern is defined in qFmt , and if qnDec is defined and not 0, the property qDec is used. If qDec is not defined, the variable DecimalSep defined at the top of the script is used.
  • If no format pattern is defined in qFmt , and if qnDec is 0, the number of decimals is 14 and the property qDec is used. If qDec is not defined, the variable DecimalSep defined at the top of the script is used.

Type is FIX

The following applies:

  • If a format pattern is defined in qFmt , the engine looks at the values set in qDec and qThou . If these properties are not defined, the engine uses the number interpretation variables included at the top of the script ( DecimalSep and ThousandSep ).
  • If no format pattern is defined in qFmt , the properties qDec and qnDec are used. If qDec is not defined, the variable DecimalSep defined at the top of the script is used.

Type is MONEY

The following applies:

  • If a format pattern is defined in qFmt , the engine looks at the values set in qDec and qThou . If these properties are not defined, the engine uses the number interpretation variables included at the top of any script ( MoneyDecimalSep and MoneyThousandSep ).
  • If no format pattern is defined in qFmt , the engine uses the number interpretation variables included at the top of the script ( MoneyDecimalSep and MoneyThousandSep ).

Type is ASCII

No formatting, qFmt is ignored.

 FieldAttributes
qRelative

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

 Boolean
qBrutalSum

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 .

 Boolean
qAggrFunc

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.

 String
qAccumulate
  • 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.
 Integer
qReverseSort

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

 Boolean
qActiveExpression

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

 Integer
qExpressions

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

 Array of String
qLabelExpression

Label expression. This parameter is optional.

 String

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