Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
jasonseril
Creator
Creator

checking the query run time

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.

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

View solution in original post

3 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Contributor III
Contributor III

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
Contributor
Contributor

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.