Qlik Community

QlikView Documents

Documents for QlikView related information.

Reload Date and Time Snippets

Honored Contributor II

Reload Date and Time Snippets


This file contains some code snippets for adding Time and Date details for when the document was last reloaded. The snippets are created as Variables, so if anyone has more snippets to add please update this file and save the new version so it can be used by others


Tags (3)
MVP & Luminary
MVP & Luminary

Hi Alan,

Thanks for sharing this.  What the ReloadTime() function won't give you is the start time of the reload and therefore you can not calculate the duration.  The way to do this is to persist the start and end times to variables during reload.  I show how to do this in this blog post: http://bit.ly/18U44Xf

Also, I believe that it is a good idea to avoid using the now() function in variables and expressions - as QlikView needs to keep evaluating those expressions over and over again.  A simple diff on time is not going to hurt too much but if you were using it to then say pull back all rows old than x minutes then it would cause QlikView to keep repeatedly parsing the data.


Version history
Revision #:
1 of 1
Last update:
‎2013-10-19 09:10 AM
Updated by: