When,Where,How To Use AGGR() Function in Qlikview?

[#1]

Hi Every One

I Am New To Qlikview  Can Anyone Explain For My Question With Suitable Example.

Thanks In Advance

[prma7799]

Hi Harish,

Please check below

http://community.qlik.com/thread/38796

Thanks

PM

[prma7799]

Or check

http://www.learnallbi.com/aggr-function-in-qlikview/

Thanks

PM

[#4]

thanks for info

[prma7799]

Hi Harish,

If you get right answer then please mark it as right and close this thread.

Thanks

PM

[JonnyPoole]

Couple of other scenarios:

Use aggr() if you need to do some kind of subtotalling in a chart on a dimension that is NOT in that same chart.

sum( total <Region> Sales)  ->  will subtotal Sales by region  (if Region is a dimension in the chart)

aggr( sum(Sales), Region)  ->  will subtotal Sales by region  (if Region is NOT a dimension in the chart)

Its also helpful if you have to do a 2 pass aggregation:

max( total aggr(sum(Sales) , Region) )  ->  will get you the region with maximum tota sales of any region (if region is or is not a dimension in the chart.

Might help a bit.  often aggr() and <total> are easily confused.