Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.

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
MVP

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

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