Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

skiruthigadevi
New Contributor

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

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

1 Solution

Accepted Solutions
xufei123
Valued Contributor

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

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

18 Replies
Khan_Mohammed
Honored Contributor II

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

=ReloadTime()

should give you when the app was last reloaded

skiruthigadevi
New Contributor

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

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

Khan_Mohammed
Honored Contributor II

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

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.

Khan_Mohammed
Honored Contributor II

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

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
New Contributor

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

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

Khan_Mohammed
Honored Contributor II

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

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
New Contributor

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

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

Khan_Mohammed
Honored Contributor II

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

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.

marmentrout5
Contributor

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

Do you have NPrinting?