Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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. 

4 Replies
its_anandrjs

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

Not applicable
Author

Hi Anand,

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

Regards

Abhinav

MK_QSL
MVP
MVP

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

its_anandrjs

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