QlikView Tutorial

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.

For any qlikview / qliksense training and consulting requirements, please reach out at learndatantools@gmail.com