topic Re: Max loaddate in QlikView

Max loaddate

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi Expertise

please find the attachment of the QVW file ..

I have a load date ..and i want to set it to max of load date within the triger of a sheet and also trying to add a action withn the text object .

but this is not working ?

Can someone please help me with this ..

I tired the below conditon it is not working .

=date(max(all LOAD_DATE),'MM/DD/YYYY')

Thanks in Avdnace

tresB — Mon, 03 Dec 2018 05:35:11 GMT

Try like:

=Date(Max({1} LOAD_DATE), 'M/D/YYYY')

Reduce no of Ds and Ms to/by one

smilingjohn — Mon, 03 Dec 2018 05:42:18 GMT

Hi MVP,

Thanks for the reply .

This is working , will this now work for all the date in future ?

Thanks

tresB — Mon, 03 Dec 2018 05:54:41 GMT

It should as far as your date format doesn't change. Please close the thread by giving Like/Accepting as correct solution.