topic Re: TRACE elapsed timespan in a QVW script in QlikView

TRACE elapsed timespan in a QVW script

Fri, 24 Apr 2015 23:05:54 GMT

Hi, I'm trying to the following in a QVW script, and am missing something in how I calculate the duration:

LET vStartTime = Now();

// [Do something that takes a few minutes]

LET vEndTime = Now();

LET vDuration = $(vEndTime) - $(vStartTime); // SCRIPT ERROR

TRACE Elapsed time: $(vDuration);

I would have thought that Using TRACE to capture the Elapsed Reload time would have answered this question, but it's missing the timespan/duration/elapsed part. I've tried using the Interval() function, but so far without success.

Can anyone correct this script? Thanks.

Re: TRACE elapsed timespan in a QVW script

srchilukoori — Fri, 24 Apr 2015 23:26:00 GMT

Try the script below.

LET vStartTime = Now();

// [Do something that takes a few minutes]

SLEEP 10000;

LET vEndTime = Now();

LET vDuration = Timestamp#('$(vEndTime)') - Timestamp#('$(vStartTime)');

TRACE Elapsed time: $(vDuration);

Re: TRACE elapsed timespan in a QVW script

Fri, 24 Apr 2015 23:35:04 GMT

Very close -- now just trying to format result in seconds...

Re: TRACE elapsed timespan in a QVW script

srchilukoori — Fri, 24 Apr 2015 23:36:25 GMT

Try this :

LET vDuration = Interval(Timestamp#('$(vEndTime)') - Timestamp#('$(vStartTime)'), 'hh:mm:ss');

Re: TRACE elapsed timespan in a QVW script

Fri, 24 Apr 2015 23:40:09 GMT

Perfect, thank you!

Re: TRACE elapsed timespan in a QVW script

maykerreyes — Fri, 19 Jul 2019 02:19:01 GMT

Excellent!!!!