topic Re: How to calculate total reload processing time in qlikview in QlikView

How to calculate total reload processing time in qlikview

Fri, 11 Apr 2014 07:19:32 GMT

Hi,

I want to calculate total reload time for application, can any one help me on this.

thanks,

Rakesh.

Re: How to calculate total reload processing time in qlikview

its_anandrjs — Fri, 11 Apr 2014 07:24:40 GMT

Code like

Let vStart = now();

Table1:

Load

Statements

From Location;

Table2:

Load

Statements

From Location;

Let vEnd = now();

Then subtract vEnd - vStart

Then take a text box to get maximum time for reloading

=Timestamp(Timestamp(Timestamp#(vEnd,'DD/MM/YYYY hh:mm:ss'),'hh:mm:ss') -

Timestamp(Timestamp#(vStart,'DD/MM/YYYY hh:mm:ss'),'hh:mm:ss'),'hh:mm:ss')

or you can create a variable like

let vTotReloadTime = Timestamp(Timestamp(Timestamp#(vEnd,'DD/MM/YYYY hh:mm:ss'),'hh:mm:ss')-Timestamp(Timestamp#(vStart,'DD/MM/YYYY hh:mm:ss'),'hh:mm:ss'),'hh:mm:ss');

Regards

Re: How to calculate total reload processing time in qlikview

MK_QSL — Fri, 11 Apr 2014 08:07:21 GMT

Add

Let vReloadStartTime= NOW();

before your script...

Add

Let vReloadEndTime= NOW();

at the end of your script..

Now enter below formula in your Text Box Expression

=TIME(vReloadEndTime-vReloadStartTime,'hh:mm:ss')

Re: How to calculate total reload processing time in qlikview

Fri, 11 Apr 2014 09:42:36 GMT

Thank u very much Anand Chauhan,my problem is solved

Re: How to calculate total reload processing time in qlikview

Fri, 11 Apr 2014 09:43:23 GMT

Hi Manish,

my problem is solved ,thanks a lot