Discussion Board for collaboration on QlikView Scripting.
When you have a query in Qlikview document/object, is there a way to check on the querying timeof the sql loading or something like that? thanks.
Go to 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 & sqlLET 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.