topic Re: How to show last data refresh time on the sheet? in QlikView

How to show last data refresh time on the sheet?

Mon, 17 Sep 2012 15:42:10 GMT

Is there a system variable available which I can use to show the last data refresh time for a sheet or for a complete document or I need to create a new vaiable for that?

Thanks,

Re: How to show last data refresh time on the sheet?

Miguel_Angel_Baeyens — Mon, 17 Sep 2012 15:43:54 GMT

Hi,

Yes, use

ReloadTime()

That will return the last time the document was reloaded.

Hope that helps.

Miguel

Re: How to show last data refresh time on the sheet?

Mon, 17 Sep 2012 15:44:02 GMT

Hi,

There is ReloadTime() function,

Regards,

Yigal.

Re: How to show last data refresh time on the sheet?

Mon, 17 Sep 2012 15:55:20 GMT

I got the refresh date and time, but it is showing me the date and time for Septmber 13th and today its 17th.

Why it is not shoiwng me the today's date?

Is it because of when the QVD last time cretaed or refreshed?

Thanks,

Re: How to show last data refresh time on the sheet?

Mon, 17 Sep 2012 16:00:33 GMT

Hi,

As Miguel wrote: "...That will return the last time the document was reloaded."

The document meens youre QVW file.

Yigal.

Re: How to show last data refresh time on the sheet?

Mon, 17 Sep 2012 16:26:47 GMT

Got it. Thank you very much guys 🙂

Re: How to show last data refresh time on the sheet?

Mon, 17 Sep 2012 16:41:39 GMT

We get SAP tables each night and we want to know the time stamp of the file. To get this use:

Load filetime() as FileTimeStamp from 'Q:\FolderName\FileName.QVD';

Stephen

Re: How to show last data refresh time on the sheet?

Tue, 18 Sep 2012 13:00:26 GMT

If I want to add some text before that e.g "Last Update:" before the time stamp, what can I write?

I wrote "='Last Reload: ' &ReloadTime()" and it worked but it is giving me the

time in the following format: 18/09/2012 08:43:15

where as I want this in the following format: 2012-09-18 08:43:15

How can I change the format of time?

Thanks,

Re: How to show last data refresh time on the sheet?

Tue, 18 Sep 2012 14:51:08 GMT

Number of ways, but one way is to go to "Setting", "Document Properties","Number", select the field and format it the way you want.

Stephen

Re: How to show last data refresh time on the sheet?

Anonymous — Tue, 10 Jul 2018 16:57:41 GMT

HI Miguel,

I use the same ReloadTime () command to show the date and time, but I need to record all those times the application was updated. It's possible?