Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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