Get last refresh dateTime of app A in an B app

[benoitgochel]

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,

[sunny_talwar · Accepted solution]

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]

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

Thank you