topic Re: Average Calculation in QlikView

Average Calculation

roee1983 — Wed, 18 Sep 2013 13:43:00 GMT

Hi All,

is there any chance to calculate both average and sum toghther in the same expression?

i need the average for total accuracy by countries average (sum(accuracy)) .

thanks

Roee

Gysbert_Wassenaar — Wed, 18 Sep 2013 14:00:30 GMT

If you want to nest aggregation functions, for example the average of sums, you need to use the aggr function.

Something like avg(aggr(sum(accuracy),country)) to get the average of the sums of accuracy per country.

roee1983 — Wed, 18 Sep 2013 14:06:06 GMT

Thanks!!

i did it wrong

aggr(avg(...)

thank u very much!

Roee