topic Re: Aggr() in QlikView

Aggr()

Wed, 14 May 2014 18:32:11 GMT

Hi all ,can any one explain why we use Aggr() function ,with some simple exp,

Re: Aggr()

Anonymous — Wed, 14 May 2014 18:40:47 GMT

Let me try to make it simple...
Say, you have a numeric field Amount, and you have field Year. Need to find a maximum amount among the years. It can be done using aggr():
max(aggr(sum(Amount),Year))

That is, you aggregate sum(Amount) by Year, and find max after that.

And, read "help"

Re: Aggr()

its_anandrjs — Wed, 14 May 2014 18:41:50 GMT

Read the below mention document it is nice one

http://community.qlik.com/blogs/qlikviewdesignblog/2013/09/09/aggregation-scope

Re: Aggr()

maxgro — Wed, 14 May 2014 19:24:13 GMT

if you try to search in the community you find many interesting info and docs about aggr

QlikView Technical Brief - AGGR

QlikView App: Aggr()

or in online help, search aggr and go to nested aggregation