Problems with rolling 12 expression.

Tue, 21 Oct 2014 11:47:19 GMT

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?

BA.KS

Re: Problems with rolling 12 expression.

Gysbert_Wassenaar — Tue, 21 Oct 2014 11:51:05 GMT

See this document: Calculating rolling n-period totals, averages or other aggregations

topic Problems with rolling 12 expression. in Qlik Learning Discussions

Problems with rolling 12 expression.

Re: Problems with rolling 12 expression.