Discussion Board for collaboration related to Creating Analytics for QlikView.
I am trying to calculate average, but the value is too low.
I have a Total of 710 with 16 unique dates.
When i do AVG(TotalAmount) it gives me 22. but it should be 44.
Ive tried to read this blog http://community.qlik.com/blogs/qlikviewdesignblog/2013/07/29/averages
but when i do =Avg( Aggr( Sum(TotalAmount), MonthYear ) ) it gives me the sum on 710.
When i select MonthYear on sep-2013 i get the right average
But when selecting Aug-2013 i get the wrong average
Nevermind! Im stupid!!
OF cause its due to my MonthYear takes all dates... DOH