Aggr

[#1]

Hello everyone,as i am new to qlikview. Can anyone help me in explaining the aggr() function in simple terms?

[Gysbert_Wassenaar]

A quote from the blog post AGGR...

When it is used, the AGGR function produces a virtual table, with one expression and grouped by one or more dimensions. The contents / result of this virtual table can then be used / aggregated by a further outer aggregation function(s).

Other interesting blog posts about the Aggr function:

• Pitfalls of the Aggr function
• When should the Aggr() function NOT be used?

[Oleg_Troyansky]

Hi Sunil,

in addition to these white papers, I could also suggest my new book QlikView Your Business, where AGGR(), Set Analysis, and many other advanced techniques are described in a form of a tutorial, with several hands-on exercises and examples of use cases.

Also, check out the agenda of the Masters Summit for Qlik, where I'm teaching Advanced Aggregation and Set Analysis in a classroom setting.

cheers,

Oleg Troyansky

[Chanty4u]

hi,

https://community.qlik.com/blogs/qlikviewdesignblog/2014/05/19/function-classes

https://community.qlik.com/message/942576#942576

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

https://community.qlik.com/blogs/qlikviewdesignblog/2015/10/05/pitfalls-of-the-aggr-function

hope this clears.

[engishfaque]

Dear Sunil,

Aggr() function: Returns a set of values of expression calculated over dimensions.

Syntax

aggr ([ distinct | nodistinct ] [{set_expression}]expression {, dimension})

Examples

1. aggr( sum(Sales), Country )    

2. aggr( nodistinct sum(Sales), Country )    

3. aggr( sum(Sales), Country, Region )

4. count( aggr( sum(Sales), Country ))

For more understanding please go through listed below link,

http://www.analyticsvidhya.com/blog/2014/02/aggr/

Kind regards,

Ishfaque Ahmed

[Anonymous]

Hi Oleg,

I've just started your book. I can't wait to get to the advanced topics.

I think they'll be a big help.

Kieron  

[Oleg_Troyansky]

kokeeffe Glad to hear!

I'm now offering a training class based on the book materials. If you think that it might be interesting for your team, please feel free to reach out!

If you like the book, please remember to leave a review on Amazon 🙂

cheers,

Oleg Troyansky

Check out my new book QlikView Your Business - The Expert Guide for QlikView and Qlik Sense