QlikView Tutorials | QlikView Rolling Total for n Period with RangeSum and Above function
Rolling sum becomes complex when you introduce aggregation of data by fiscal year or fiscal quarter and that’s when you need to look at alternate ways of finding correct rolling sum as per your needs.
In this video I’ve talked about how to achieve rolling sum using RangeSum and Above function along with TOTAL qualifier. Also showed couple of different scenarios based on the change in the formula.
I hope you’ll find this video useful and an addition to your learning of QlikView.
-Abhishek
![Power BI - How to Remove Aggregation Text [Sum of] from Titles and Legend Text](https://images.videosashka.com/watch/k93_ZO0VZus)
