Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi QV Community,
I have a problem w/ building a qlikview application that I hope that you guys can help me sort out. I want to present monthly data containing:
Month, Sales, Sales (Prev. Month), Budget, accumulated yearly Sales, Rolling 12
Everything works fine excluding the rolling 12 expression. The expression I use for rolling 12 is:=Sum(Aggr(rangesum(above(sum({$<date>}Premie)*1/12,0,12)),date))
The problem arises when I choose to present only one month. The calculation of the expression gives spurious results thou it does not have 12 periods to accumulate over . Do you have a better way to solve this problem or do I have to script it?
BR
BA.KS
See this document: Calculating rolling n-period totals, averages or other aggregations