Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I wanted to know if this is possible in Qlikview. See below table: I am wondering if it is possible to get a rolling accumulation for the year 2013 then have the sum begin new at the beginning of 2014 the chart is broken out into Month/Year. The desired value is in RED and BLUE
Any help would be greatly appreciated!!!
Thanks
Month / Year | Value | Accumulation |
Jan-13 | 5 | 5 |
Feb-13 | 10 | 15 |
Mar-13 | 4 | 19 |
Apr-13 | 5 | 24 |
May-13 | 12 | 36 |
Jun-13 | 5 | 41 |
Jul-13 | 8 | 49 |
Aug-13 | 10 | 59 |
Sep-13 | 2 | 61 |
Oct-13 | 5 | 66 |
Nov-13 | 10 | 76 |
Dec-13 | 20 | 96 |
Jan-14 | 2 | 2 |
Feb-14 | 5 | 7 |
Mar-14 | 8 | 15 |
Apr-14 | 17 | 32 |
May-14 | 20 | 52 |
Jun-14 | 10 | 62 |
Jul-14 | 5 | 67 |
Sep-14 | 8 | 75 |
Oct-14 | 6 | 81 |
Nov-14 | 10 | 91 |
Dec-14 | 15 | 106 |
Hi Loren,
Try with:
-Sum({<Month={"<=$(=Num(Max(Month)))"}, Year={$(vMaxYear)}>} Value)
-JFlorian
Try use
SUM (TOTAL( 'FIELD') )
tks
Try this
RangeSum(above(Sum(Value),0,Calendar.MonthNo))
You should have a field with a number of month. In my case it's Calendar.MonthNo