QlikView App Dev

[rustyfishbones]

Hi All,

I have an issue trying to calculate time for a task to be complete.If I have a picktime of 301 seconds or more, I need to reduce the picktime to 300 seconds.

Also, Is it possible to create something in the Script Editor, so if the EndPreviousTime is greater than 300 seconds (or 5 minutes) to the Start Time, I want to create a new EndPreviousTime.

So if you see below Example, on line 4 of the tablebox, you can see there is a Picktime of 2284 seconds since the previous end time, as this is over the 300 seconds I want to change the EndPreviousTime. So in below example my new EndPreviousTime would be 01:50:46 instead of 01:17:40.

[#2 · Accepted solution]

Alan,

If you want to modify the field directly in the table, you may use Rangemin, rangemax ....

Recomputed End Previous Time:  time(rangemax(EndPreviousTime, EndTime-Rangemin(Duration, '00:05:00')))

Recomputed Duration : time(rangemin(Duration, '00:05:00'))

Fabrice

[rustyfishbones]

AUNEZ,

That works great as an expression in the chart.And I could use this!

Can I use Rangemax and Rangemin in the Script Editor?

The reason I would like to do this in the Script Editor is that I need to show headline numbers of Durations in text objects etc...

[#4]

Alan,

These functions work also in script (like rangesum ....)

Fabrice

[rustyfishbones]

Thanks AUNEZ,

The same expression can be used in the Script Editor

Thanks so much

Regards

Alan