I appreciate your time and help. I am actually looking for a way to get the reloadtime of a QlikSense report in an excel file. Could you kindly let me know your suggestions?
Thanks in advance!
Solved! Go to Solution.
I suggest that you add the following code to the end of the script of every QlikView document:
let vDocumentName = DocumentName();
'$(vDocumentName)' as Document,
now() as LastRefresh
Store DocumenRefreshTable into D:\AppFolder\$(vDocumentName).qvd (qvd);
It will save the document name and last refresh time into one QVD file.
Please make sure you save them in the same folder and it is better in this folder there are only these QVD files, no other files.
Then you can create another QlikView application to load these QVD files and then export the result to one csv file.
The code in the new application should look like this:
store FinalTable into FinalTable.csv (txt);
This is the final result in the csv file:
Yes, but I want the same to get captured in an excel and once I reload the report, the reload time in excel should update automatically.
Is there any way to do the same?
how do you plan to generate this XL?
In Qlik Sense you'd have to export the excel from charts...
You individually cannot generate excel automatically.
Only way I could think of is
In your table or chart create a new measure as maybe
and Label as
='Reload Time -' & ReloadTime()
This would create an extra column but would show your reload time.
Not really clean way to do it.
Sure, but I an looking for a way for the excel to get updated automatically with the new time when I reload the report again.
Update in your local system or a folder?
In Qlik app it will get updated automatically.
Can you please explain in detail?
So for eg: when I reload the report at 1 PM , I could get the reload time in a chart and export to excel.
So the excel has reload time 1 PM.
now when I reload at 1:30 PM, The reload time in QlikSense will get update to 1:30 PM but I am looking for a way to get 1:30 PM in the excel as well without manually updating or exporting again the same as 1:30 PM from 1:00 PM.
As far as I know I don't think that's possible.
You can timestamp QVD each time you reload it...
whoever came up with that requirement ask them to use their fingers tips to be more healthy...
without clicking on either a button or chart or whatever the updated XL will not not change by magic.