Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Load max date for a row of data

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.

1 Solution

Accepted Solutions

Re: Load max date for a row of data

May be this

Date(RangeMax(Date1, Date2, Date3)) as MaxRowDate

2 Replies

Re: Load max date for a row of data

May be this

Date(RangeMax(Date1, Date2, Date3)) as MaxRowDate

Not applicable

Re: Load max date for a row of data

This worked perfectly. Thank you so much!