Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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.
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.