topic Re: Agg function in QlikView

Agg function

alec1982 — Tue, 17 Jul 2012 17:43:38 GMT

Hi,

May andbody explain to me the use of agg function.

maybe with a little sample.

Thxs,

Re: Agg function

cesaraccardi — Tue, 17 Jul 2012 17:54:55 GMT

Hi,

lets say you have the following table:

Order ID	Item	Value
1	A	10
1	B	5
1	C	2
2	A	3
2	D	4
3	B	6
3	E	3

Then you want to know the average value by Order... if you just use an expression like avg(Value), the result will be the average by Item (4.71) and not by Order (11). So in this case you need to change the aggregation, and thats the purpose of the Aggr function.

In this case you could use something like:

avg(aggr(sum(Value), [Order ID]))

This expression means the average of the Values aggregated by Order ID.

Regards,
Cesar.

Re: Agg function

alec1982 — Tue, 17 Jul 2012 18:05:19 GMT

Hi,

thanks for the replay..

Would that mean the result will be:

1 (10+5+2)/3

2 (3+4)/2

3 (6+3)/2

Thxs,

Re: Agg function

cesaraccardi — Tue, 17 Jul 2012 18:37:28 GMT

Hi,

Thats right. The expressions with aggr may look a little confuse if you dont visualize it with a sample, but the concept is really simple.

Regards,
Cesar.

Re: Agg function

alec1982 — Tue, 17 Jul 2012 19:05:12 GMT

Thxs for the quick responses.

Re: Agg function

Tue, 28 Jan 2014 15:03:46 GMT

Hi Cesar,

I have small doubt after looking at the explanation which u have posted.The expression has to be the same as above.But if we use that in Bar char as the dimension if we use OrderID then what will be the result.Please clarify this doubt.

Regards,

Deepthi