topic Re: Time Expression, Start Time-End Time in QlikView

Time Expression, Start Time-End Time

rustyfishbones — Mon, 24 Feb 2014 15:20:56 GMT

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.

Re: Time Expression, Start Time-End Time

Mon, 24 Feb 2014 15:42:14 GMT

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

Re: Time Expression, Start Time-End Time

rustyfishbones — Mon, 24 Feb 2014 15:56:32 GMT

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

Re: Time Expression, Start Time-End Time

Mon, 24 Feb 2014 16:04:07 GMT

Alan,

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

Fabrice

Re: Time Expression, Start Time-End Time

rustyfishbones — Mon, 24 Feb 2014 16:05:02 GMT

Thanks AUNEZ,

The same expression can be used in the Script Editor

Thanks so much

Regards

Alan