Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
The file attached is an extract form my QV solution. The problem I am having is in column C (4 weeks rolling average) which returns a wrong value regardless of how much I change up the expression. I found this formula from these discussion threads
moving average in qlikview | Qlik Community
Kindly someone help me out on what exactly is going wrong in my calculations?
Cheers
Since you didn't post a qlikview document that shows what you're actually doing and the data you're using I can only suggest you try the approach described in this document: Calculating rolling n-period totals, averages or other aggregations