Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Implement Timestamp


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

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

Not applicable

Hi Anand,

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




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


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.






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.