Qlik Community

QlikView Documents

Documents for QlikView related information.

Reload Date and Time Snippets

rustyfishbones
Honored Contributor II

Reload Date and Time Snippets

Hi,

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

Thanks

Tags (3)
Attachments
Comments
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.

Steve

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