topic Displaying reload time in QlikView

Displaying reload time

Anonymous — Sun, 28 Jan 2018 07:42:00 GMT

Hi,

Is it possible to display the last reload time of an application in the dashboard.

Thanks,

Remya

Re: Displaying reload time

karthikoffi27se — Sun, 28 Jan 2018 08:28:59 GMT

Hi Remya,

Assign a variable at the end of the script as vEndReloadTime = now() ; and pull this variable into the dashboard. This will show the last reload time of the dashboard.

Many Thanks

Karthik

Re: Displaying reload time

Anonymous — Sun, 28 Jan 2018 10:24:03 GMT

Thanks for your reply.

I have assigned task in qmc to reload the data every one hour, i need to display that time.

Re: Displaying reload time

surendraj — Sun, 28 Jan 2018 11:31:15 GMT

you can show last reload time in textbox.

'Last reload on - ' & reloadtime()

Re: Displaying reload time

Or — Sun, 28 Jan 2018 13:19:36 GMT

Just keep in mind that this is when the reload finished - the actual information contained will likely be older than the reloadtime(), as it will be up to date based on the individual load, not the end of the full reload script.

Re: Displaying reload time

Anonymous — Mon, 29 Jan 2018 05:58:57 GMT

Hi,

Thanks for your help.

Its showing the last reload which I did manually, what I need is last reload of application from the server.

Re: Displaying reload time

Siva_Sankar — Mon, 29 Jan 2018 08:04:54 GMT

Hi Remya,

Keep the below formula in a text box in your dashboard. It will show the last reload time irrespective of whether you reload manually or by server automatically.

'Last reload on - ' & reloadtime()

-Siva