When do I use the Aggr() function in an expressin, when in dimension and when as calculated dimension and when as dynamic?

[#1]

Would be great if someone can explain when to use the function and wherere and how to use it.

[hic]

The Aggr creates an array of aggregations, which you can use for nested aggregations or for dynamic dimensions.

See more on

Aggr...

QlikView Technical Brief - AGGR.docx

When should the Aggr() function NOT be used?

HIC

[#3]

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.

[#4]

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)