Capture and Store Data Reload Time History

[KKumar92]

Hi All,

I am using the following variables to capture the last data reload date and time in the script,

Let vReloadDate = Date(Today(), 'DD/MM/YYYY');
Let vReloadTime = ReloadTime();

The above variables are working and return the latest figures, however, I want to record the history of data reload take place for a given app,  please advise on how I could store the history of data reload date and time in the Qlik Sense front UI.

Please refer to the table below for the expected output.

vReloadDate	vReloadTime
11/11/2002	8.00 pm
12/11/2020	9.30 am
12/11/2020	11.00 am
12/11/2020	11.15 am
12/11/2020	12.00 pm

[tresesco]

@KKumar92 

You can store this information in a qvd and keep the record (here the single column information of reload time) adding to it and then load it at a later point of time.

[KKumar92]

@tresesco 

I have tried the above option, but it only displays the last reload time, where as I want to record the history of reload time for a given application.

[tresesco]

@KKumar92 Try like:

Let vReloadTime = ReloadTime();

t1:
Load
	'$(vReloadTime)' as ReloadHistory
AutoGenerate 1;

If Not IsNull(QvdCreateTime('lib://qs/reloadHistory.qvd')) then
	Load ReloadHistory from [lib://qs/reloadHistory.qvd](qvd);
End If    

STORE t1 into [lib://qs/reloadHistory.qvd] (qvd);