Aggr()

[#1]

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

[Anonymous]

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"

[its_anandrjs]

Read the below mention document it is nice one

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

[maxgro]

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