Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
davdiste
Partner
Partner

How to display the date of the last data load in a text box?

Hi,

Someone know wich is function to display the date of the last data load in a text box?

I attach the result of what I want to insert in a text box inside the report.

Thanks

7 Replies
oknotsen
Master III
Master III

This is the function you are looking for:

reloadtime()

May you live in interesting times!
kimrormark
Creator
Creator

Yep. Write =reloadtime() or maybe ='Last reload: ' & reloadtime()

Not applicable

This is what I use and it works perfectly.

='[ Last updated: '& Now(0)&' ]'

Now(0) returns the time at the last finished reload

oknotsen
Master III
Master III

I would not advise to use the now() function as it is bad for performance. That function results in constantly re-calculating your sheet.

May you live in interesting times!
Not applicable

Now() should only constantly recalculate when the timer mode is 1/default, correct? 

davdiste
Partner
Partner
Author

Thanks!

kimrormark
Creator
Creator

Yep.

0 is reload time

1 is actual now (recalculating and triggers refresh every second)

2 is document opened time (opened by user)