topic Re: When,Where,How To Use AGGR() Function in Qlikview? in QlikView

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

Fri, 06 Mar 2015 06:44:49 GMT

Hi Every One

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

Thanks In Advance

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

prma7799 — Fri, 06 Mar 2015 06:48:00 GMT

Hi Harish,

Please check below

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

Thanks

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

prma7799 — Fri, 06 Mar 2015 06:49:32 GMT

Or check

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

Thanks

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

Fri, 06 Mar 2015 07:02:59 GMT

thanks for info

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

prma7799 — Fri, 06 Mar 2015 07:13:29 GMT

Hi Harish,

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

Thanks

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

JonnyPoole — Fri, 06 Mar 2015 16:34:10 GMT

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.