Peek function used like rangesum in script

Thu, 22 Aug 2013 21:13:57 GMT

Is it possible to use the peek function in the script similar to the rangesum(above()) function?

I have the following formula in a pivot and need to transfer the same functionality to the script.


if(rangesum(above(sum(if([Hours Code]='',[Paycor Hours])),0,RowNo()))<=40,0,

if(rangesum(above(sum(if([Hours Code]='',[Paycor Hours])),1,RowNo()))>40,
sum(if([Hours Code]='',[Paycor Hours])),
if(rangesum(above(sum(if([Hours Code]='',[Paycor Hours])),1,RowNo()))<=40,
rangesum(above(sum(if([Hours Code]='',[Paycor Hours])),0,RowNo()))-40))))

+

sum(if([Hours Code]='OT',[Paycor Hours]))

This formula is calculating Overtime over a week. I need the script to look at all the days of the previous week to current record, and then change the formula weather 40 hours has been reached. This needs to then be reset to start the process over for each new week. This will give me several fields based on each days specific row.

overtime

standard time

field standard time

field overtime

night premium

night premium overtime

night premium field overtime

Since the night premium is specific to the day that it was worked on, I need this function to calculate if at that time they had reach overtime or not. The final result is a summary for each employee, hence why I need this done on the script level

Re: Peek function used like rangesum in script

whiteline — Sat, 24 Aug 2013 19:30:36 GMT

Hi, Marc.

I would say like above, cause the rangesum is still useful in this case.

Of course, you have to preapare a table properly sorted and aggregated.

Then create a separete field for calculating rolling sum with peek -ing the same field, reseting the accumulation each time the new week starts.

topic Peek function used like rangesum in script in QlikView

Peek function used like rangesum in script

Re: Peek function used like rangesum in script