Data timestamp

[#1]

I have seen reports with a box showing the data load time and date. Can someone tell me how this is done ?

Thank you.

[johnw]

I agree with and use the last two suggestions (start of reload, time of QVD). My typical application has an "About" page that includes the start of the reload, and the timestamps of all QVDs (and sometimes other data sources) that were used in the application. It's probably mostly for my own benefit - I doubt users check the about page. So when knowing the currency of the data is more important, I sometimes put the most relevant date or timestamp on every page, and change the font color to red if it is older than would normally be acceptable. Other applications (not my own) even have a pop up to warn users that the data is stale, so that you're CERTAIN they're aware that they shouldn't completely trust the data. We also have procedures in place to alert the QlikView administrators (of which I am one) when reloads fail, and when applications have not been reloaded in a given period of time.

Here's an example of my usual display of the reload information on the About tab:

[#3]

How would you build up the table shown above in your QV application ? Do you upload it using variables or is there a way to store the QVDcreatetimes in a table by means of a load command ?

Reason for my asking is that I a have a QV application that consists of aggregated data tah can be reloaded at any time by means of an external event, but also detail data that is only refreshed once a day (because of performance reasons on the operational server on which the data resides).

As we are always reloading our Qlikview applications from QVD files (optimized loads), I want to add a tab in the application where I can actually see for each QVD file what it's last reload time / creation time has been. The Now() or Lastreloadtime() function doesn't mean anything if you are reloading from QVD files, as the timestamp of the QVD file will tell you the timestamp of data shown in the application.

The same applies for the end user using the application. Reloadtime doesn't mean a single thing when using QVD files.

[johnw]

You can load the qvdcreatetimes without variables. I've recently started doing it like the script below. Most of our QVDs are in the same place and have usable names, so it can be done pretty simply. If you had QVDs in several different places, and wanted your display names to differ from the QVD names, you could probably do a two-field load, one for the name you wanted to see, and one for the location and name of the QVD.

[Data Source Load Times]:
LOAD
"Data Source"
,evaluate('qvdcreatetime(' & chr(39) & '..\..\server\MasterData\QVD\'
& replace("Data Source",' ','_') & '.qvd' & chr(39) & ')') as "Last Loaded"
INLINE [
Data Source
Address
Bill Of Lading
Catalog
Coil
Customer
Order Acknowledgement Captions
Order Item
Product Type
Tally
Tally Coil
Truck Control
];

[#5]

John,

My case is similar to that of Xavier has mentioned. I reload different data tables at different time periods(hourly, daily and monthly). So I have classified my sheets to daily, hourly & monthly catageries(based on tables they use and created qvds for each sheet) and scheduled reload for QVDs.

My master QVW reloads everytime there is a hourly/monthly/daily reload is succesful in server. I have all QVDs sorted into different folders.

Now I want to present the reload time of data on each sheet based on reload time of their QVDs, instead of reload time of master QVW. How do I do that?  

please help me with the coding part.

Krishna

[rwunderlich]

You can get the "reload time" for any qvd with the function:

QvdCreateTime('path\myfile.qvd')

-Rob