Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
kishorj1982
Creator II
Creator II
‎2017-11-09 01:33 AM

Cumulative sum not working

Hi all,

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

Please suggest.

thanks

sample.qvw
398 Views
0 Likes
2 Replies
PrashantSangle
MVP
MVP
‎2017-11-09 01:40 AM

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 🙂
354 Views
PrashantSangle
MVP
MVP
‎2017-11-09 01:43 AM

In response to PrashantSangle

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 🙂
354 Views