Cumulative SUM in Qlik Expression

[gsiva1220]

Hi Experts,

I explain what I would like to achieve in Qlikview, I have a below data,

Britem	Creation Date	Line Id	Qty
JXX19643	21-Jul-17	4869992	3
JXX19643	21-Jul-17	4957114	2
JXX19643	14-Aug-17	4908295	1
JXX19643	14-Aug-17	4908296	1
JXX19643	13-Sep-17	4955603	1
JXX19643	13-Sep-17	4955604	2
JXX19643	1-Sep-17	4937133	1

I would like to calculate the Qty and show it as below

Britem	Creation Date	Line Id	Qty	Expected Qty
JXX19643	21-Jul-17	4869992	3	0
JXX19643	21-Jul-17	4957114	2	3
JXX19643	14-Aug-17	4908295	1	5
JXX19643	14-Aug-17	4908296	1	6
JXX19643	13-Sep-17	4955603	1	7
JXX19643	13-Sep-17	4955604	2	8
JXX19643	1-Sep-17	4937133	1	9

Can anyone please let me know, how can I achieve the expected Qty using set analysis or other expressions.

[sunny_talwar · Accepted solution]

May be try this

RangeSum(Above(TOTAL Sum(Qty), 1, RowNo(TOTAL)))

[elintham]

Hi Sunny,

I've been looking through your answers to Qlik Community Questions on Cumulative Sum.

Would you be able to help with this one?

We're having troubles trying to get the cumulative percentage in a pivot table?
Please see this thread:

Calculating Cumulative Percentage of Total by Column (Pivot Table)

Thank you!!

[DSDD]

Hi Sunny,

is it possible to calculate the cumulative sum for a further grouping-dimension.

Let say i have a field with two categories and i want to display the cumulative qty in a line chart with two lines

How do i adjust the expression to consider the grouping dimension?