topic Re: checking the query run time in QlikView

checking the query run time

jasonseril — Wed, 29 Jul 2009 07:37:13 GMT

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.

checking the query run time

rwunderlich — Wed, 29 Jul 2009 08:35:33 GMT

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

Re: checking the query run time

luxlux80 — Wed, 29 May 2019 16:53:34 GMT

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-Accesss-failed/td-p/1586274.

Thanks.

Re: checking the query run time

rageshjaiswal28 — Fri, 25 Sep 2020 13:52:34 GMT

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.