Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
benoitgochel
Contributor III
Contributor III

Get last refresh dateTime of app A in an B app

Hi everyone,

I have a "QVD generator" (A) app that fetch data from my databases for 3-4 others qlik apps in order not to duplicate them.

In the others apps that uses the QVDs generated by the first one (A), I would like to display the last dateTime of this (A) app.

How can I proceed?

Thank you in advance,

1 Solution

Accepted Solutions
sunny_talwar

Store this information in a qvd which can then be added....

LastReloadTime:

LOAD Now() as LastReloadTime

AutoGenerate 1;

Store LastReloadTime into LastReloadTime.qvd;

DROP Table LastReloadTime;

You can add this at the beginning or end of the script based on what time you need. If you need the reload start time, put it in the beginning. If you need end time, then put this at the end.

View solution in original post

2 Replies
sunny_talwar

Store this information in a qvd which can then be added....

LastReloadTime:

LOAD Now() as LastReloadTime

AutoGenerate 1;

Store LastReloadTime into LastReloadTime.qvd;

DROP Table LastReloadTime;

You can add this at the beginning or end of the script based on what time you need. If you need the reload start time, put it in the beginning. If you need end time, then put this at the end.

benoitgochel
Contributor III
Contributor III
Author

Well, that's a quick and very clever answer.

Thank you