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
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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

Labels (1)
Labels
sample.qvw
516 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 🙂
472 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 🙂
472 Views