Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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