topic Re: Last Execution time for each QVD generated in QlikView

Last Execution time for each QVD generated

ivandrago — Thu, 24 Apr 2014 15:16:08 GMT

Hi,

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

Thanks

Re: Last Execution time for each QVD generated

rustyfishbones — Thu, 24 Apr 2014 15:17:49 GMT

Do you mean the last reload time?

Re: Last Execution time for each QVD generated

nagaiank — Thu, 24 Apr 2014 15:18:12 GMT

The log file will help.

Re: Last Execution time for each QVD generated

its_anandrjs — Thu, 24 Apr 2014 15:19:34 GMT

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();

Re: Last Execution time for each QVD generated

MK_QSL — Thu, 24 Apr 2014 15:21:13 GMT

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)

Re: Last Execution time for each QVD generated

rustyfishbones — Thu, 24 Apr 2014 15:26:07 GMT

you can create a variable like

start = now();

LOAD

Field1,

Field2

FROM MyData.qvd(qvd);

finish = now();

duration = TIME(finish - start);

Re: Last Execution time for each QVD generated

ivandrago — Thu, 24 Apr 2014 20:14:57 GMT

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

Re: Last Execution time for each QVD generated

MK_QSL — Thu, 24 Apr 2014 20:39:27 GMT

Are you looking of time to create QVD ?

or time to load all QVDs in single qvw ?

Re: Last Execution time for each QVD generated

sundarakumar — Thu, 24 Apr 2014 20:48:21 GMT

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

Re: Last Execution time for each QVD generated

ivandrago — Fri, 25 Apr 2014 12:18:38 GMT

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

Re: Re: Last Execution time for each QVD generated

sundarakumar — Fri, 25 Apr 2014 15:08:47 GMT

PFA, I the start and end time are same in the app as it is a very small application.

I have used now as the flag. While concatenating all the data in the main application u can use the latest time as flag.

I have shown the data creation for one qvd. similar tables should be created in the other qvd's also.

all these qvd's that are created an be concatenated in the main application, which can be used as the master qvd data details.

Hope this helps.

-Sundar

Re: Re: Last Execution time for each QVD generated

its_anandrjs — Fri, 25 Apr 2014 15:17:57 GMT

You can load your table like below

It is a example do changes from your own table

LET vStart = Now();

LET Tablename = 'Customer';

$(Tablename):

SQL SELECT *

FROM Customers;

LET vEnd = now();

Let vtottime =TIME(vEnd-vStart,'hh:mm:ss');

LOAD * Inline

[

Start,End,Tablename,ExecutionTime

'$(vStart)','$(vEnd)','$(Tablename)','$(vtottime)'

];