Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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

4 Replies
MK_QSL
MVP
MVP

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

its_anandrjs

Hi,

Write SET expression to avoid selections

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


Regards,

Anand

its_anandrjs

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

prieper
Master II
Master II

Hi,

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

HTH Peter