Last Execution time for each QVD generated

[ivandrago]

Hi,

I want to know the last eexcution time and how long the Task took generate the QVD file? Is this possible?

Thanks

[rustyfishbones]

Do you mean the last reload time?

[nagaiank]

The log file will help.

[its_anandrjs]

Write a load script like

Let vStart = now();

Load

Statements

From Location;

Let vEnd = now();

Let Totaltime = time(( vEnd- vStart),'hh:mm:ss') ;

Or may be Reloadtime() function

Let vLastUpdated = Reloadtime();

[MK_QSL]

at the start of the script

Let vReloadStartTime = NOW();

at the end of the script

Let vReloadEndTime = NOW();

Add Below in text box

=Time(vReloadEndTime-vReloadStartTime)

[rustyfishbones]

you can create a variable like

start = now();

LOAD

Field1,

Field2

FROM MyData.qvd(qvd);

finish = now();

duration = TIME(finish - start);

[ivandrago]

Hi,

Thanks for the reply, basically I have about 5 Documents that generate about 10 qvd's. I then have a qlikview document that pulls all these qvd's and then I create different dashboards etc.. what I am after is section within the Document to tell the users the reload times for each QVD and how long it took to cretae the qvd. So based on what you were saying   about the vReloadStartTime at the start of the sheet and then do the vReloadEndTime at the end of the last sheet for each of my QVD Generators how do I call these variables for my main Document?

Thanks

[MK_QSL]

Are you looking of time to create QVD ?

or time to load all QVDs in single qvw ?

[sundarakumar]

save these details in a separate table in all the five qvd generators and pull these five tables into the main application.

Ppl have already shared details of how to capture these data. Create a table called reload time and put these data in.

In the mail application concat all the data and create a master reload time table.

Show the user the reload time of each qvd from this table.

Hope this helps.

-Sundar

[ivandrago]

So How do you store these variables into a qvd file?

So I am guessing that

So I have done the following:

//Put this at the start of each sheet

vReloadStartTime = NOW();

//Put this at the end of each sheet

vReloadEndTime = NOW();

So How do you store these variables into a qvd file? I am guessing I would want the followinf fields

QVD Name, --Name of the QVD that is being generated

Start Time, -- Start time of when the QVD Begins

End Time -- End Time of when the QVD End

Execution Time, --THis would be the caulation time of End Time minus Start Time

Flag -- I was thinking that if i was to keep a history of all reload times then to create a Flag so 1 would be the latest for each QVD