Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

export active document last reload date to a QVD or text file

Hi I want a way to export the active qlikview document 'last reload date only' to either a QVD file or Text file.

I currently have the following script that creates a variable of reload time.

LET vScriptReload=RELOADTIME();

How can i get this to export to a qvd/text file for a chosen path?

Regards

1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

LET vScriptReload=RELOADTIME();
ReloadTable:
LOAD
DocumentName() as Docname,
'$(vScriptReload)' as ReloadTime
AUTOGENERATE 1
;
STORE ReloadTable INTO mypath\ReloadTracker.qvd;

Or to store as text:
STORE ReloadTable INTO mypath\ReloadTracker.txt (txt);

Note that in this context, RELOADTIME() is the wrong function to use. ReloadTime() is not reset until the end of script, so will return the ReloadTIme of the last script execution. Instead use:
LET vScriptReload=now(1);

-Rob