Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Would be great if someone can explain when to use the function and wherere and how to use it.
The Aggr creates an array of aggregations, which you can use for nested aggregations or for dynamic dimensions.
See more on
QlikView Technical Brief - AGGR.docx
When should the Aggr() function NOT be used?
HIC
Well I readed the documents but I still don t understand it the proper way when to use a calculated dim, dynamic dim or expression. May be you have some simple examples.
when u want find the sales for row wise
aggr is like adding the multiple dimension
ex:
aggr(sum(sales),id,product))
or
aggr(sum(sales)product)