Solved: Re: Regarding getting the reload time of a QlikSen... - Qlik Community

skiruthigadevi · ‎2018-11-08

Hi Friends,

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!

Best Regards,

Kiruthiga

NZFei · ‎2018-11-08

I suggest that you add the following code to the end of the script of every QlikView document:

let vDocumentName = DocumentName();

DocumenRefreshTable:
Load
'$(vDocumentName)' as Document,
now() as LastRefresh
AutoGenerate 1;

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:

FinalTable:
LOAD
Document,
LastRefresh
FROM
(qvd);

store FinalTable into FinalTable.csv (txt);

This is the final result in the csv file:

Fei

View solution in original post

MK9885 · ‎2018-11-08

=ReloadTime()

should give you when the app was last reloaded

skiruthigadevi · ‎2018-11-08

Hi Mohammed,

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?

Thank you,

Kiruthiga

MK9885 · ‎2018-11-08

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.

MK9885 · ‎2018-11-08

Only way I could think of is

In your table or chart create a new measure as maybe

Chr(13)

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.

skiruthigadevi · ‎2018-11-08

Hi Mohammed,

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.

Thank you,

Kiruthiga

MK9885 · ‎2018-11-08

Update where?

Update in your local system or a folder?

In Qlik app it will get updated automatically.

Can you please explain in detail?

skiruthigadevi · ‎2018-11-08

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.

Thank you,

Kiruthiga

MK9885 · ‎2018-11-08

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.

Thanks.

Tanalex · ‎2018-11-08

Do you have NPrinting?

Regarding getting the reload time of a QlikSense report in an excel/text file