topic Re: Last load date of Data.. in QlikView

Last load date of Data..

Mon, 08 Dec 2014 17:48:13 GMT

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

Re: Last load date of Data..

MK_QSL — Mon, 08 Dec 2014 17:49:07 GMT

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

Re: Last load date of Data..

its_anandrjs — Mon, 08 Dec 2014 17:51:55 GMT

Hi,

Write SET expression to avoid selections

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

Regards,

Anand

Re: Last load date of Data..

its_anandrjs — Mon, 08 Dec 2014 18:00:20 GMT

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' )

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

Regards

Anand

Re: Last load date of Data..

prieper — Mon, 08 Dec 2014 21:40:15 GMT

Hi,

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

HTH Peter