Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi qlikview communtity,
I am trying to make a accumulative sum on a straight table but nothing seems to work. I have the belowtable:
Date | EmplRef | MinutesWorked | FlexGained |
59 | |||
14/10/2013 | FL238 | 464 | -16 |
15/10/2013 | FL238 | 481 | 1 |
16/10/2013 | FL238 | 513 | 33 |
17/10/2013 | FL238 | 481 | 1 |
21/10/2013 | FL238 | 465 | -15 |
22/10/2013 | FL238 | 535 | 55 |
I have tried the FullAccumulation option, rangesum(above(FlexGained)) options so far none of them worked.
Any ideas???
Yes, using peek.
LOAD *, RangeSum(FlexGained,peek(AccumFlexGained)) as AccumFlexGained INLINE [
Date, EmplRef, MinutesWorked, FlexGained
14/10/2013, FL238, 464, -16
15/10/2013, FL238, 481, 1
16/10/2013, FL238, 513, 33
17/10/2013, FL238, 481, 1
21/10/2013, FL238, 465, -15
22/10/2013, FL238, 535, 55
];
In my occation a get some large 7 digit negative numbers if use the above funtion..
So it does not calculate correctly...
Any other ideas??