Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Maybe like attached?
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.
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.
Any suggestion please.