Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

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 (3)
1 Reply
Highlighted