Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Master II
Master 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
Highlighted
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.

View solution in original post

5 Replies
Highlighted
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.

Highlighted
Master II
Master 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

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

View solution in original post

Highlighted
Master II
Master II

Re: Using TRACE to capture the Elapsed Reload time

Yes that worked

I had both in the main sheet

Thanks a lot Carlos

Highlighted
Contributor III
Contributor III

Re: Using TRACE to capture the Elapsed Reload time

How do you find the difference between the 2 timestamps?