Skip to main content Skip to complementary content

General syntax for aggregations

The following general syntax structure can be used for aggregations, with many optional parameters:

aggrexpression ::= ( fieldref | operator1 aggrexpression | aggrexpression operator2 aggrexpression | functioninaggr | ( aggrexpression ) )

fieldref is a field name.

functionaggr ::= functionname ( parameters2 )

Expressions and functions can thus be nested freely, as long as fieldref is always enclosed by exactly one aggregation function and provided the expression returns an interpretable value, QlikView does not give any error messages.

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: ampquestions@qlik.com