Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

benoitgochel
New 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

Re: Get last refresh dateTime of app A in an B app

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.

2 Replies

Re: Get last refresh dateTime of app A in an B app

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
New Contributor III

Re: Get last refresh dateTime of app A in an B app

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

Thank you

Community Browser