Cumulative Sum based on a date in Qlik Sense Bar chart

[Chris272727]

Hi Everyone,

I would like to show Cumulative sum in a bar chart in Qlik based on the date and below is my sample data. 

ExtractionDate	Records
6/4/2021	14190
6/5/2021	15250
6/6/2021	15290
6/7/2021	15330
6/8/2021	15370
6/9/2021	15410
6/10/2021	15450
6/11/2021	15490

I tried with below formula and  not gettting expected output and Attached bar chart.

aggr(rangesum(above(Sum(Records),0,RowNo())),ExtractionDate)

Please suggest me any solution if possible.

Thanks

Chris

[sunny_talwar · Accepted solution]

How about if you just use this

RangeSum(Above(Sum(Records), 0, RowNo()))

[Chris272727]

Thanks for the quick Reply. I tried with that and it doesnt work. Please see below thread where similar issues was posted and correct solution was provided you. https://community.qlik.com/t5/New-to-Qlik-Sense/cumulative-sum-in-bar-chart/td-p/33644

[sunny_talwar]

What do you see when you use this expression? Give an error message or just gives the wrong numbers?

[Chris272727]

Sorry, there was an issue at my end.  It is working fine now.

Thank you so much!!