Re: Cumulative sum not working - Qlik Community

kishorj1982 · ‎2017-11-09

Hi all,

I have created the cumulative sum but for sales order column it is not working.

Please suggest.

thanks

PrashantSangle · ‎2017-11-09

Hi,

Instead of using RangeSum() you can try with full accumulation.

Regards,

Prashant Sangle

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

PrashantSangle · ‎2017-11-09

Also, Your Rangesum() expression is working You need to use

rangesum(Above(sum(SalesOrder ),0,RowNo(Total)))

instead of

rangesum(Above(sum(ThirdPartySales),0,RowNo(Total)))

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂