Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
rustyfishbones
Honored Contributor II

Using TRACE to capture the Elapsed Reload time

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

1 Solution

Accepted Solutions
Not applicable

Re: Using TRACE to capture the Elapsed Reload time

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.

5 Replies
Not applicable

Re: Using TRACE to capture the Elapsed Reload time

You can use the now function in the script:

LET InicioRecarga = now();

LET FinRecarga = now();

Then use those variables to get the elapsed time.

rustyfishbones
Honored Contributor II

Re: Using TRACE to capture the Elapsed Reload time

Hi Carlos,

That gives me the same time for both

so the duration will always be 0

I am looking for something like this

duration.png

Not applicable

Re: Using TRACE to capture the Elapsed Reload time

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.

rustyfishbones
Honored Contributor II

Re: Using TRACE to capture the Elapsed Reload time

Yes that worked

I had both in the main sheet

Thanks a lot Carlos

prasadmundewadi
New Contributor III

Re: Using TRACE to capture the Elapsed Reload time

How do you find the difference between the 2 timestamps?