topic Re: Aggr() in QlikView

Aggr()

Mon, 14 Dec 2015 12:56:46 GMT

Hi ,

I need to know regarding the AGGR() Function.

Can someone explain me please?

Thanks

its_anandrjs — Mon, 14 Dec 2015 13:04:46 GMT

Better you read this threads,.

Regards

Anand

tresB — Mon, 14 Dec 2015 13:05:03 GMT

Read it here:

Anonymous — Mon, 14 Dec 2015 13:06:11 GMT

check this & see the attachment as well:

Mon, 14 Dec 2015 13:16:42 GMT

Thanks

All

Will surely go through each one

Mon, 14 Dec 2015 13:36:45 GMT

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!

Thu, 14 Jan 2016 15:09:00 GMT

Thanks Leira!!!