Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
jasonseril
Contributor

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

checking the query run time

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

1 Reply

checking the query run time

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

Community Browser