Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

Problems with rolling 12 expression.

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?



1 Reply
MVP & Luminary
MVP & Luminary

Re: Problems with rolling 12 expression.

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

talk is cheap, supply exceeds demand
Community Browser