Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Tags (1)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: accumulative sum not working

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.


talk is cheap, supply exceeds demand
11 Replies
Not applicable

Re: accumulative sum not working

Hi,

Please try this one:

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

Not applicable

Re: accumulative sum not working

Try this

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

hope it will help

Not applicable

Re: accumulative sum not working

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

Not applicable

Re: accumulative sum not working

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

Not applicable

Re: accumulative sum not working

will you attach the sample

MVP & Luminary
MVP & Luminary

Re: accumulative sum not working

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.


talk is cheap, supply exceeds demand
Not applicable

Re: accumulative sum not working

Thats it...You are right.

er_mohit
Honored Contributor II

Re: accumulative sum not working

try this

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

Not applicable

Re: accumulative sum not working

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