topic Max date selection in QlikView

Max date selection

smilingjohn — Mon, 26 Nov 2018 10:38:06 GMT

Hi All,
Please find the attachment of the QVW application.
Here i have a multibox which has a load date field ..i want to set the max of laod date for which i have the trigger ..

at first it worked .but when i select different date and change the sheet and come back to the Max sheet it doesnt select the max of load date.

Can please someone help me on this ..I am confused

Thanks

Re: Max date selection

Marco — Mon, 26 Nov 2018 10:51:50 GMT

Change the expression in:

=date(max(ALL [Load Date]),'MM/DD/YYYY')

Re: Max date selection

sunny_talwar — Mon, 26 Nov 2018 12:20:11 GMT

You can also use {1} to ignore selection in all fields or {<[Load Date]>} to ignore selection in Load Date field

=Date(Max({1} [Load Date]), 'MM/DD/YYYY')

=Date(Max({<[Load Date]>} [Load Date]), 'MM/DD/YYYY')