Datapoint which shows most recent SQL execution time

[koscumbs]

Hello all,

I'm wondering if there's any datapoint that's generated by Qlik (or how to create one, if there's not) every time I load data into a QlikView.  In essence, I want to know how long each Qlik app takes to run, export, and create joins from the SQL queries I've used to source my analyses.

Anyone have any ideas?

Thanks in advance!

[vishsaggi · Accepted solution]

May be this not sure if this is what you want.

Use this variable before your LOAD Script.

LET vReloadTime = Now();

All your load scripts or SQL scripts here.

LET vReloadEndTime = Now();

Then in your sheet use a text box like

= 'Refresh Time Taken: ' & Interval(vReloadEndTime - vReloadTime, 'mm:ss')

[koscumbs]

I'm pretty sure this is going to work -- thanks Vishwarath!