topic Re: accumutative sum in script in QlikView

accumutative sum in script

Wed, 23 Oct 2013 14:34:53 GMT

Hi qlikview communtity,

I am trying to make a accumulative sum in the script 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 managed to do it on a straight table but I need it inside the script.

Already tried:

RangeSum(FlexGained,peek(AccumFlexGained)) as AccumFlexGained

but i got some lagre negative numbers back isted of an accurate result

Any ideas???

Re: accumutative sum in script

Wed, 23 Oct 2013 15:09:29 GMT

Im sorry for my english but this works Niko :

Primero:

LOAD * 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

];

Segunda:

load

Date,

EmplRef,

MinutesWorked,

FlexGained,

RangeSum(FlexGained,peek(AccumFlexGained)) as AccumFlexGained

Resident Primero;

DROP TABLE Primero;

Regards!

Re: accumutative sum in script

Wed, 23 Oct 2013 15:49:46 GMT

Hi Raul and thanks for the quick responce,

I can see that it works on your version but the behaviour on my impementation is not the same.

I use the exact same formula to calculate the running average but insted I get numbers like -6607388,-6607185

and so forth.

I can not figure out why is that....

Can anyone help?? Has anyone had any similar issue??

Re: accumutative sum in script

Thu, 24 Oct 2013 07:43:03 GMT

Any ideas??? I have been trying everything but with no luck..

Re: accumutative sum in script

tresB — Thu, 24 Oct 2013 07:46:11 GMT

Could you share your sample app?

Re: accumutative sum in script

Thu, 24 Oct 2013 07:59:52 GMT

Here is a sample,

I it took me a minute to hide some sensitive information.

As you can see in the employee number = FL238 i what i am accually trying to achieve is to reset the flex to 480 if its more than that every friday and to keep accumulating from that flex afterwards. I would appreciate your help

Re: accumutative sum in script

tresB — Thu, 24 Oct 2013 08:05:50 GMT

Hi,

A quick fix before going into details; try putting single quotes around field name in peek() like:

RangeSum(FlexGained,peek('AccumFlexGained')) as AccumFlexGained