Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am loading a table with some date fields in Qlik Sense:
LOAD
TRIM(DATE(Date1)),
TRIM(DATE(Date2)),
TRIM(DATE(Date3))
FROM ...
;
I want to add 1 more field that holds the distinct maximum date from the 3 date fields above for that row of data.
Each of these date fields (as well as the new maximum date field) can be null.
How do I do this?
Thank you.
May be this
Date(RangeMax(Date1, Date2, Date3)) as MaxRowDate
This worked perfectly. Thank you so much!