Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ashishpalkar
Contributor II

Get max date from selected dates

Hi There

I want to get max date from selected dates.

e.g I have field called 'Start Date'. When user selects multiple dates we want to display the max date from selected dates.


Thanks in advance,

4 Replies
Employee
Employee

Re: Get max date from selected dates

=Date(Max([Start Date]))

ashishpalkar
Contributor II

Re: Get max date from selected dates

Hi Toni

thanks for responding, this is giving me Max date of the 'Start date'. How ever I want max date from user selected values.

Hope this helps, 

diwaskarki
Contributor

Re: Get max date from selected dates

Hello Toni,

Any idea why my script below is giving me a script error:

LOAD
AuditAutoFireOffices,
AuditAutoFireRequestee,
Date(Max(
Completed_Date)),
(
UPPER(AuditAutoFireOffices) & '.' & Upper(AuditAutoFireRequestee)) As 'Audit Correlation Key'
RESIDENT SPT_AUDIT_EVENT;

I appreciate the help. Thanks

arvind654
Honored Contributor II

Re: Get max date from selected dates

Maybe create a variable in script?

And use the variable in your expression

LET MaxDate= 'Max(Completed_Date)';

$(MaxDate) in front end