Average from Average

Sat, 26 May 2012 11:11:37 GMT

Hi to all

I am new to qlikview and have one question concerning diagramm calculation. In a simplified manner we have the following table.

I would like to calculate the average from average grouped by the article.

If I use the simple avg-function "avg(rating)" in a diagramm or table, the avg. rating for this table is: (10 + 30 + 100) / 3 = 46.7

The value I look for is the average rating - first grouped by the article

( (10 + 30 ) / 2 + 100 ) / 2 = 60

ball has an average rating from 20

goal has an average rating from 100

the total average rating is (20 + 100 ) / 2 = 60

What is the expression / formula I have to enter to get 60 and not 46.7 ?

Thank you very much for your help.

Greetings

swuehl — Sat, 26 May 2012 13:13:40 GMT

Try

=avg( aggr( avg(Rating), Articel))

So group your avg(Rating) by Articel and get the average from that.

aggr() is advanced aggregation which you need to use if you want to embed an aggregation function like average inside another aggregation function.

topic Average from Average in QlikView