Cumulative sum in Qlikview

[#1]

Hi All,

I am new to Qlikview, can any please help me how can I do Cumulative sum in Qlikview , I have an employee data and counting based on year and Quarter as Dimensions to count data for each quarter.

If I select year 2013, it should count all the data stating from last year, in my case id should count all the employees who joined in 2010, 2011, 2012 and 2012. Below is my sample data and expected output.

INPUT
JOIN_DT_YEAR	JOIN_DT_QUARTER	Q1	Q2	Q3	Q4
2010		1	2	3	5
2011		10	8	5	3
2012		9	2	7	3
2013		7	5	5	0
OUTPOT
JOIN_DT_YEAR	JOIN_DT_QUARTER	Q1	Q2= (Q1+Q2)	Q3=(Q2+Q3)	Q4(Q3+Q4)
2010		1	3	6	11
2011		21	29	34	37
2012		46	48	55	58
2013		65	70	75	75

Thanks in advance.

[swuehl]

Maybe like attached?

[#3]

Thank you Swuehi, for quick turnaround.

If I am not filtering anything that's fine, if I filter any year (let's say 2013), it should sum the entire Sales amount from 2009 to 2013, so it should come 1500 instead of 500.

Any suggestions.

[swuehl]

Sorry, I don't get your point. The max aggregated values is 75, not 500 or 1500.

And if I select year 2013 in my sample, the aggregated values don't change.

[#5]

Any suggestion please.