Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

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

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

Tags (1)
3 Replies
Employee
Employee

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

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

Not applicable

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

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.

Not applicable

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

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)

Community Browser