Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Implement Timestamp

hI

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. 

Tags (2)
4 Replies
Highlighted

Re: How to Implement Timestamp

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

Highlighted
Not applicable

Re: How to Implement Timestamp

Hi Anand,

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

Regards

Abhinav

Highlighted
MVP
MVP

Re: How to Implement Timestamp

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

Highlighted

Re: How to Implement Timestamp

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