topic Re: accumulative sum not working in QlikView

accumulative sum not working

Wed, 23 Oct 2013 10:04:39 GMT

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

Re: accumulative sum not working

Wed, 23 Oct 2013 10:09:37 GMT

Hi,

Please try this one:

=rangesum(Above(sum(FlexGained),1,RowNo()))

Re: accumulative sum not working

Wed, 23 Oct 2013 10:10:21 GMT

Try this

rangesum(above(Flexgained,0,rowno()))

hope it will help

Re: accumulative sum not working

Wed, 23 Oct 2013 10:12:13 GMT

Nop. No luck. I got only zero values on all rows.

Re: accumulative sum not working

Wed, 23 Oct 2013 10:13:16 GMT

This did not work either. I got the FlexGained values replication on each row.

Re: accumulative sum not working

Wed, 23 Oct 2013 10:14:32 GMT

will you attach the sample

Re: accumulative sum not working

Gysbert_Wassenaar — Wed, 23 Oct 2013 10:18:02 GMT

Since you're using two dimensions you need the total keyword in the above() function:

rangesum(above(total sum(FlexGained),0,RowNo(total)))

See attached example.

Re: accumulative sum not working

Wed, 23 Oct 2013 10:19:09 GMT

Thats it...You are right.

Re: accumulative sum not working

er_mohit — Wed, 23 Oct 2013 10:21:43 GMT

try this

rangesum(above(sum(FlexGained),0,rowno()))

Re: accumulative sum not working

Wed, 23 Oct 2013 12:28:54 GMT

What about doing the same calculation inside the script. Is that possible ??? using peek or above or something like that??

Re: accumulative sum not working

Gysbert_Wassenaar — Wed, 23 Oct 2013 12:34:50 GMT

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

];

Re: accumulative sum not working

Wed, 23 Oct 2013 13:00:47 GMT

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