Rolling Cumulative Sum Set Analysis

[BrandonN]

Hi everyone,

Need helps on rolling cumulative Sum in Set analysis. 
Is there anyway I can achieve rolling cumulative sum in set analysis?  

I tried expression SUM(Date={">=$(vLast3Month)<=$(vMaxDate_CY)"} SalesAmount) but in Line chart I am not getting the cumulative and rolling sum for every 3 months. 

Thank you

[Or · Accepted solution]

Have a look at this resource:

https://community.qlik.com/t5/QlikView-Documents/Calculating-rolling-n-period-totals-averages-or-oth...

[anat]

RangeSum(

               Above( total Sum(  SalesAmount)

        ,           0, 3)

                    )