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.