topic Re: Using TRACE to capture the Elapsed Reload time in QlikView

Using TRACE to capture the Elapsed Reload time

rustyfishbones — Thu, 13 Jun 2013 21:46:14 GMT

I want to use TRACE to get the RELOAD start time and the RELOAD finish time

I then want to add a text box to show the Elapsed time of the RELOAD

start time - finish time = duration of reload

I know it's possible, but I cannot get it to work for me

Re: Using TRACE to capture the Elapsed Reload time

Thu, 13 Jun 2013 21:57:22 GMT

You can use the now function in the script:

LET InicioRecarga = now();

LET FinRecarga = now();

Then use those variables to get the elapsed time.

Re: Using TRACE to capture the Elapsed Reload time

rustyfishbones — Thu, 13 Jun 2013 22:09:08 GMT

Hi Carlos,

That gives me the same time for both

so the duration will always be 0

I am looking for something like this

Re: Using TRACE to capture the Elapsed Reload time

Thu, 13 Jun 2013 22:15:46 GMT

You would have to place the " LET FinRecarga = now(); " at the end of the script in order to get the last execution time of the script. If your script takes miliseconds to execute, then it will be almost the same time for both variables.

Re: Using TRACE to capture the Elapsed Reload time

rustyfishbones — Thu, 13 Jun 2013 22:29:24 GMT

Yes that worked

I had both in the main sheet

Thanks a lot Carlos

Re: Using TRACE to capture the Elapsed Reload time

prasadmundewadi — Thu, 28 Mar 2019 13:57:45 GMT

How do you find the difference between the 2 timestamps?