Рет қаралды 5,624
AGGR function is very powerful to create #calculated dimensions specially measure based on run time. For Example, Avg sales bracket of customers etc.
The Aggr function is used for nested aggregations, in which its first parameter (the inner aggregation) is calculated once per dimensional value. The dimensions are specified in the second parameter (and subsequent parameters).
#Qlik #qliksense #aggr #Groupby #calculateddimension #class
#sum in dimension