Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Database Refresh Time-stamp on Document

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

1 Solution

Accepted Solutions
giakoum
Honored Contributor II

Re: Database Refresh Time-stamp on Document

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

4 Replies
giakoum
Honored Contributor II

Re: Database Refresh Time-stamp on Document

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

Not applicable

Re: Database Refresh Time-stamp on Document

Thanks - this worked for me!

giakoum
Honored Contributor II

Re: Database Refresh Time-stamp on Document

Please Rob close this discussion as Answered.

Thank you.

Not applicable

Re: Database Refresh Time-stamp on Document

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

Community Browser