topic Displaying the last refresh time in QlikView

Displaying the last refresh time

Wed, 11 Jun 2014 12:52:02 GMT

Hi all,

I have a report which i put on qlikview server.

On server only, the report gets reloaded.

when a user is accessing the report via Browser, I need to show the last refreshed time of the report.

I had used Document trigger for POSTLOAD, but it did not work when i used the report on server.

I tried to set a variable in refresh script, the variable got initialized with 'now()'

so in GUI, it is showing the values as clock.

Is there any other way for doing this.

Thanking in advance.

its_anandrjs — Wed, 11 Jun 2014 13:00:05 GMT

You can use the ReloadTime() function but best is NOW()

Eg:-

Let vLastRefresh = NOW();

and display this variable in the Application on any text Object

='Application Refreshed at '&$(vLastRefresh)

alexandros17 — Wed, 11 Jun 2014 13:03:24 GMT

write in a textbox:

='Last Update: ' & date(ReloadTime(),'DD/MM/YYYY hh:mm:ss')

P.S. using NOW() will force the document to check (every second) its status, slowing it ....

Anonymous — Wed, 11 Jun 2014 13:12:26 GMT

Use ReloadTime() function

Put the below the line in a text object.It will display the lasr reload time.

='Last Refreshed: ' & Date(ReloadTime(),'MM/DD/YYYY hh:mm:ss TT')

Wed, 11 Jun 2014 13:19:09 GMT

Hi all,

Thanks for replying.

Being new to Qlikview, i did not know about the ReloadTime() function.

I did it in the following way-

1. Setting a variable at the end of the load

a- Let lastreload = Now()

2. Displaying the value of the variable in the UI.