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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get overall average of moving range data?

There are two line charts in my QV app (attached): one is the original data, the another one is the moving range- the difference between data point and the previous data point. The moving range is calcuated using Above function. I tried to get the overall average for the moving range data in second chart by using a variable. Just cannot get it done after many tries. I used this function

=Avg(Aggr(Fabs(Avg(intMin)-Above(Avg(intMin))),YearMonth))

, unfortunately it just does not work. Please advise.

Thanks

 

0 Replies