topic Re: 'Refresh/Data last load' time stamp in QlikView

'Refresh/Data last load' time stamp

Tue, 18 Nov 2014 03:03:50 GMT

We scheduled a Qlik View report on server and that report refresh every hour. Is it possible to display refresh time (data last load) in Qlik? Please let us know what field we need to track.

Re: 'Refresh/Data last load' time stamp

SergeyMak — Tue, 18 Nov 2014 03:12:39 GMT

Hi,

The function is

ReloadTime()

Regards,

Sergey

Re: 'Refresh/Data last load' time stamp

Tue, 18 Nov 2014 03:58:03 GMT

Use reloadtime() function

Re: 'Refresh/Data last load' time stamp

jagan — Tue, 18 Nov 2014 05:17:46 GMT

Hi,

You can use ReloadTime() to get the Last reload timestamp, please use below expression in text object to display in Dashboard

='Last Refreshed On : ' & ReloadTime()

Regards,

jagan.

Re: 'Refresh/Data last load' time stamp

Tue, 18 Nov 2014 13:21:59 GMT

Hi Raguthu,

you can use the Function Reloadtime(). If you want to convert that time according to your local time you can use, in the second parameter you can put your localtime, place.

='Last Refreshed On : ' & ConvertToLocalTime(Reloadtime(), ’GMT-05:00’)

='Last Refreshed On : ' & ConvertToLocalTime(Reloadtime(),’Paris’)

With Regards

Harshita Gaur