Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculate AVG

Hello,

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.

2 Replies
Not applicable
Author

Notice!

When i select MonthYear on sep-2013 i get the right average

But when selecting Aug-2013 i get the wrong average

Not applicable
Author

Nevermind! Im stupid!!

OF cause its due to my MonthYear takes all dates... DOH