topic Re: Datapoint which shows most recent SQL execution time in QlikView

Datapoint which shows most recent SQL execution time

koscumbs — Fri, 01 Dec 2017 15:52:14 GMT

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!

Re: Datapoint which shows most recent SQL execution time

vishsaggi — Fri, 01 Dec 2017 16:42:20 GMT

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')

Re: Datapoint which shows most recent SQL execution time

koscumbs — Fri, 01 Dec 2017 19:13:21 GMT

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