Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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