Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
ashishpalkar
Creator III
Creator III

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
ToniKautto
Employee
Employee

=Date(Max([Start Date]))

ashishpalkar
Creator III
Creator III
Author

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
Creator II
Creator II

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

MK9885
Master II
Master II

Maybe create a variable in script?

And use the variable in your expression

LET MaxDate= 'Max(Completed_Date)';

$(MaxDate) in front end