How to calculate total reload processing time in qlikview

[#1]

Hi,

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

thanks,

Rakesh.

[its_anandrjs]

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

[MK_QSL · Accepted solution]

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

[#4]

Thank u very much Anand Chauhan,my problem is solved

[#5]

Hi Manish,

my problem is solved ,thanks a lot