Skip to main content Skip to complementary content

Expression syntax for calculated formulas

The syntax for expression in calculated labels is virtually the same as for chart expressions, with a few exceptions:

  • With no dimensions to iterate over, the chart aggregation functions will essentially behave as if used in chart expressions with the total qualifier in front of all field names. The total qualifier is thus optional and has no special meaning in calculated formulas. The set definitions work just as in chart expressions, i.e. they cause aggregations over a selection different than the current one.

  • In a calculated formula, field names may optionally be used without an enclosing aggregation function. In this case only will be used as an aggregation function.


= Currency

is equal to

= only(Currency)

Learn more


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!

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: