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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Vinothishere
Contributor III
Contributor III

Average Calculation

Hi All,

    I have daily sales forecast data till 2017, I have to calculate the average of next three weeks sales in chart expression.For every week  I have to display the average of next 3 weeks value.

     How to calculate?

Thanks in advance

Regards,

VR

6 Replies
Vinothishere
Contributor III
Contributor III
Author

I have tried this expression sum( aggr( rangeavg(below( sum(sales),0,3) ),Week)) but it is not returning correct result

MK_QSL
MVP
MVP

You have to create as of table !

Read the full blog and try to implement the same !

Vinothishere
Contributor III
Contributor III
Author

Is there any way to calculate it in the chart expression?

MK_QSL
MVP
MVP

You can but on selecting certain field, will alter your result.

Vinothishere
Contributor III
Contributor III
Author

I have created asof table but its not returning expected result.