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 to spark ideas for how to put the latest capabilities into action. Register here!
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: 
Rdelavega
Contributor
Contributor
‎2019-07-02 12:25 PM

Cumulative Sum of a Column

Hello,

I learned in this forum that the fuction "RangeSum" combined with "Above" can cumulative sum a column, however this is not working for me and i wanted to ask for your help.

Qlik.JPG

 

 

 

 

In the image you can see two columns with ID and client Name. next I have 2 more columns with money sent and money received. next column would be the column(2)-column(1) result (received - sent) and in the last column I want to show the cumulative result of (received - sent). unfortunately, it seems i'm worng in the formula and the last column is showing Column(3) instead.

the formula i'm using is Rangesum(Above(Column(3),0,RowNo())). I also tried with Rangesum(Above(SUM(Column(3)),0,RowNo())) but i does not work either.

thanks in advance for your help

Labels (1)
Labels
1,268 Views
0 Likes
1 Reply