Aggr()

[#1]

Hi ,

I need to know regarding the AGGR() Function.

Can someone explain me please?

Thanks

[its_anandrjs]

Better you read this threads,.

https://community.qlik.com/blogs/qlikviewdesignblog/2013/05/06/a-historical-odyssey-qlikview-7

https://community.qlik.com/docs/DOC-4279

Regards

Anand

[tresesco]

Read it here:

AGGR...

Pitfalls of the Aggr function

[Anonymous]

check this & see the attachment as well:

Aggr() function

Aggr function in QlikView | Learn QlikView

[#5]

Thanks

All

Will surely go through each one

[#6]

Hi Sahoo, suppose that you have this table:

CITY | SALES | YEAR

BOSTON | 1000 | 2014

NEW YORK | 1200 | 2014

CHICAGO | 2000 | 2014

BOSTON | 1500 | 2015

CHICAGO | 1000 | 2015

If you apply the aggr() function for example aggr( sum(sales) , city ) you are grouping the sales for city.

So, if you do a listbox with city like dimension and aggr( sum(sales) , city ) like expression you get this:

CITY | SALES

BOSTON | 2500

NEW YORK | 1200

CHICAGO | 3000

You are getting the sales for cities. So, the aggr() function serves to grouping a dimension applying a expression.

I hope that it help you!

[#7]

Thanks Leira!!!