Displaying the last refresh time

[#1]

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]

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 · Accepted solution]

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]

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')

[#5]

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.