topic Re: Database Refresh Time-stamp on Document in QlikView

Database Refresh Time-stamp on Document

Thu, 30 Aug 2012 13:18:31 GMT

I would like to include a text box object on each document that lets users know when the last refresh was of the data they are working with. How would I pull this information and place it on document sheet?

Thanks for any insight!!

Rob

Re: Database Refresh Time-stamp on Document

giakoum — Thu, 30 Aug 2012 13:20:42 GMT

As off date : ' & TIMESTAMP(RELOADTIME())

Re: Database Refresh Time-stamp on Document

Mon, 13 May 2013 14:08:30 GMT

Thanks - this worked for me!

Re: Database Refresh Time-stamp on Document

giakoum — Tue, 14 May 2013 08:00:10 GMT

Please Rob close this discussion as Answered.

Thank you.

Re: Database Refresh Time-stamp on Document

Tue, 14 May 2013 08:10:54 GMT

Two things here,

1.Database Refresh time

This specific to the data and nothing to do with QV application where the database has been last refreshed. This can be achieved by taking the max of the Updated Date field (a field that should be available in your fact tables or you should having some 'run info' table or any table, table name may be different where they store the last successful runtime or execution time of the database)

Load this table as an island table into QV and,

Let vLastUpdatedDate= max(updateddate)

use this in ur text obj ='Data last refreshed date :' & $(vLastUpdatedDate)

2.QV Reload Time

='Data as of :' & QvReloadTime(), as suggested in the above post

should work