Cumulative sum over date ascending but order descending

[joboro]

Hi, I have the following source table:

date	quantity
2021-01-01	1
2021-01-02	1
2021-01-03	4
2021-01-04	9

I would like to have the following table:

date	quantity	accum_quantity
2021-01-04	9	15
2021-01-03	4	6
2021-01-02	1	2
2021-01-01	1	1

What set analysis should is use for "accum_quantity"? If the output table would be sorted by date ascending i could use the formula: 

Rangesum(ABOVE(Sum(QUANTITY),0,rowno()))

 The best case would be that the sum is independent from the sort order of the table...

KR

[SunilChauhan]

try this 
RangeSum(Below(Sum(Quantity), 0, RowNo(TOTAL)))

[joboro]

Unfortunately not: 

[SunilChauhan · Accepted solution]

Sorry Mybad use below

RangeSum(Below(Sum(Quantity), 0, NoOfrows(TOTAL)))

[joboro]

Yes, thats look about right. Thanks!

Do you also know a solution to make it sort order independent? Currently i have to use two different measures depending weather i sort by date descending or ascending.

[SunilChauhan]

it would be sort based on only one either ascending or descending.

[joboro]

yes, but if the user clicks on the column name and changes the sort order the values don't add up

[SunilChauhan]

is it happening to Pivot table also?

[joboro]

Yes, as long as the user has the ability to change the sort order, the calculations are off

[SunilChauhan]

Not sure on this . you may check this thread 

https://community.qlik.com/t5/App-Development/Qlik-Sense-how-to-disable-sort-feature-on-straight-tab... 

Hope this give some insight.