Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to do cumulative sum in qliksense (Interview question
)
Hello Sekharapp,
I was able to find the following within the Qlik Community:
RangeSum(Above(TOTAL Sum(Qty), 1, RowNo(TOTAL)))
https://community.qlik.com/t5/QlikView-App-Dev/Cumulative-SUM-in-Qlik-Expression/td-p/1399466
RangeSum(Above(TOTAL Sum(Qty), 0, RowNo(TOTAL)))
I hope this helps!
Hello Sekharapp,
I was able to find the following within the Qlik Community:
RangeSum(Above(TOTAL Sum(Qty), 1, RowNo(TOTAL)))
https://community.qlik.com/t5/QlikView-App-Dev/Cumulative-SUM-in-Qlik-Expression/td-p/1399466
RangeSum(Above(TOTAL Sum(Qty), 0, RowNo(TOTAL)))
I hope this helps!
Also, please let us know if these formulas / links help with what you are trying to do by clicking on the box "Accept as Solution"