1 Reply Latest reply: Oct 21, 2014 7:51 AM by Gysbert Wassenaar RSS

    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?

       

      BR

      BA.KS