topic Re: How to Implement Timestamp in QlikView

How to Implement Timestamp

Tue, 08 Apr 2014 17:19:56 GMT

we are daily connecting to database to load the QVD using QVD_Generator.qvw.

how can we implement the concept of Timestamp(Start time,Endtime)

if we(QVD Team) loading the QVD , the dashboard team has to know that here is a qvd refersh

based on Timestamp. so they has to stop .. if we are not loading the qvd they have to continue.

Using Time stamp What we are going to achieve is

when the real program has started executing...If the QVD Load(Refresh) still running and there is no end timestamp then they have to read the start timestamp and

think that the program is still running this time so wait for some more time or go

to the next resfresh. if the next refresh is also having the same timestamp then it means there is a problem with qvd refresh.

Re: How to Implement Timestamp

its_anandrjs — Tue, 08 Apr 2014 17:36:05 GMT

Use Reloadtime() in the QVD maker then it will give you exact time stamp data time.

Re: How to Implement Timestamp

Tue, 08 Apr 2014 17:49:29 GMT

Hi Anand,

Can u elaborate more... how to write that one...

Regards

Abhinav

Re: How to Implement Timestamp

MK_QSL — Tue, 08 Apr 2014 18:15:10 GMT

Before Loading the QVD...

Let vStartTime = NOW();

Load QVD Script...

Let vEndTime = NOW();

Now you can use this variable in your UI end to find out about QVD run or not...

Something like in Text Box

=Time(vEndTime - vStartTime,'hh:mm:ss')

Re: How to Implement Timestamp

its_anandrjs — Tue, 08 Apr 2014 18:25:41 GMT

Before running Real program you have get the last reload time of the application then you are able to give a QVD team to refresh the QVD.

Eg:-

Load

FIelds

From Location;

By a variable you can store the last reload time in time stamp

Let vReloadtime = Reloadtime();

When you get the time in variable take a variable in any text box and give information about last reload time of the application according to last reload time whenever it is not completed the QVD scheduler not start. So based on the scheduler give reload refresh time to the QVD generator.

Regards