checking the query run time

[jasonseril]

When you have a query in Qlikview document/object, is there a way to check on the querying time
of the sql loading or something like that? thanks.

[rwunderlich · Accepted solution]

Are you asking about the time it takes to do the SQL query in the load script? You can get a pretty good idea from looking at the logfile.

Or you can bracket your script statements with something like this:

LET START = now(1);
do the load & sql
LET ELAPSED = now(1) - ELAPSED;

Then display the variable in a text object as "=interval(ELAPSED, 'hh:mm:ss')"

Or are you looking for how long it takes for an object to display after making selections? Those values are available inthe Sheet Properties/Objects tab in the "Calc Time" column.

-Rob

[luxlux80]

Rob,

I have followed as per your solution.

It works with no section access, for the app with section access, "Access denied" message displayed.

Please refer the post https://community.qlik.com/t5/Qlik-Sense-App-Development/Qlik-sense-Query-runtime-log-with-Section-A....

Thanks.

[rageshjaiswal28]

Hi, 

LET START = now(1);

do the load & sql

LET ELAPSED = now(1) - START;

Then display the variable in a text object as "=interval(ELAPSED, 'hh:mm:ss')"

#Rwunderlich, for calculating ELASPED you need to subtract now -  START.