Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Not applicable

Last load date of Data..

Hi All,

we are displaying when the data was last updated in DWH.on right upper corner of the application..

we are writing the below code for it,

 

='LAST LOAD DATE : '& max(date([DWH LAST UPDATED DATE],'DD-MMM-YYYY'))

The last load date is changing as per the selection... For example If i select year prompt..its showing one date and if i select any region,,its showing another date..

can you please let me know how to achive this to do not change the date.. thanks in advance

Tags (3)
4 Replies
Highlighted
MVP
MVP

Re: Last load date of Data..

='LAST LOAD DATE : '& max({1}date([DWH LAST UPDATED DATE],'DD-MMM-YYYY'))

Highlighted

Re: Last load date of Data..

Hi,

Write SET expression to avoid selections

='LAST LOAD DATE : '& max({1}date([DWH LAST UPDATED DATE],'DD-MMM-YYYY'))


Regards,

Anand

Highlighted

Re: Last load date of Data..

But why you not use the ReloadTime()  or Now() function for the same you can use it like

='LAST LOAD DATE : '& date( ReloadTime(),'DD-MMM-YYYY' )


Or


='LAST LOAD DATE : '& date( Now(),'DD-MMM-YYYY' )



Regards

Anand

Highlighted
Honored Contributor II

Re: Last load date of Data..

Hi,

why not display the result of the internal variable reloadtime()?

HTH Peter