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???
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.
Hi,
Please try this one:
=rangesum(Above(sum(FlexGained),1,RowNo()))
Try this
rangesum(above(Flexgained,0,rowno()))
hope it will help
Nop. No luck. I got only zero values on all rows.
This did not work either. I got the FlexGained values replication on each row.
will you attach the sample
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.
Thats it...You are right.
try this
rangesum(above(sum(FlexGained),0,rowno()))
What about doing the same calculation inside the script. Is that possible ??? using peek or above or something like that??