topic Re: Max date in QlikView

Max date

smilingjohn — Mon, 26 Nov 2018 10:19:36 GMT

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

Re: Max date

tresB — Mon, 26 Nov 2018 09:50:29 GMT

Put date() around search string expression like:

Re: Max date

smilingjohn — Mon, 26 Nov 2018 10:19:59 GMT

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

Re: Max date

tresB — Mon, 26 Nov 2018 10:11:02 GMT

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