topic Re: Cumulative sum in Qlikview in QlikView

Cumulative sum in Qlikview

Tue, 23 Jul 2013 16:15:52 GMT

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.

Re: Cumulative sum in Qlikview

swuehl — Tue, 23 Jul 2013 17:34:55 GMT

Maybe like attached?

Re: Cumulative sum in Qlikview

Tue, 23 Jul 2013 18:06:34 GMT

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.

Re: Cumulative sum in Qlikview

swuehl — Tue, 23 Jul 2013 21:15:38 GMT

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.

Re: Cumulative sum in Qlikview

Fri, 02 Aug 2013 18:48:07 GMT

Any suggestion please.