topic Re: Aggr function in QlikView

Aggr function

Mon, 10 Dec 2012 00:01:08 GMT

Hello,

I have the following values in a table

I am looking to add the values in the to_send column for every [id Campaña].

The result I am expecting is 8:

3 [id Campaña=2] + 3 [id Campaña=3] + 2 [id Campaña=4] = 8

I've been trying to use the aggr function: AGGR(SUM(to_send),[id Campaña]) but I couldn't get that result.

Any ideas con how to solve this?

Anonymous — Mon, 10 Dec 2012 01:57:26 GMT

If there's always just one unique to_send value for each Campana, then you should be able to do:

sum(AGGR(SUM(distinct to_send),[id Campaña]))

or you could use Max() (or min() 😞

sum(AGGR(MAX(to_send),[id Campaña]))

Mon, 10 Dec 2012 02:57:41 GMT

Shudn't u expect 8 instead of 6, 3+3+2=8

Why 6 ?

Regards

Mon, 10 Dec 2012 03:02:01 GMT

yes you are right, it should be 8...I already corrected it.

Mon, 10 Dec 2012 03:06:04 GMT

Thank you for your help Johannes..it's working!