Max date

[smilingjohn]

Hi All,

please find the attachment of the Qlikview file .

I have two sheets Main ans sheet1

i am using a filter called "Date" and i need it to select the max date when i land on the main sheet ...
But iam not able to achive this ..I have also set the trigger ..can someone please help me with this ..

thansk in Advance

[tresesco]

Put date() around search string expression like:

[smilingjohn]

Hi Tresesco. 

I tried the option you suggested but it is not working .. 

I am attaching the file with your suggestion included with the trigger

[tresesco · Accepted solution]

Date formats different in the field and in the system variable you have. Try adding right format in the search string expression, like:

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