Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

accumulative sum not working

Hi qlikview communtity,

I am trying to make a accumulative sum on a straight table but nothing seems to work. I have the belowtable:

DateEmplRefMinutesWorkedFlexGained
59
14/10/2013FL238464-16
15/10/2013FL2384811
16/10/2013FL23851333
17/10/2013FL2384811
21/10/2013FL238465-15
22/10/2013FL23853555

I have tried the FullAccumulation option, rangesum(above(FlexGained)) options so far none of them worked.

Any ideas???

11 Replies
Gysbert_Wassenaar

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

];


talk is cheap, supply exceeds demand
Not applicable
Author

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??