Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

jcharles
New Contributor III

How do I create another column in the same table that takes the max date from 3 other date columns

I would like to know how to create a new column called "ClosedStatusDate" in the table below and then the data in this column should be the max date out of the 3 columns called "Date Finalised", "Date Closed" and "Date Converted" (Whichever has the last date). If there is no date then "ClosedStatusDate" will be blank.

Please help? Should be fairly easy but I'm a beginner. Thank you

The table looks like this:

Case IDDate ReportedDate FinalisedDate ClosedDate Converted
1234529/10/200931/11/201302/02/2011
1234623/05/201204/02/2014
1234701/03/201314/06/2013
1234822/01/201424/01/2014
1234931/01/2014
1 Solution

Accepted Solutions
Not applicable

Re: How do I create another column in the same table that takes the max date from 3 other date columns

I would use the rangemax() function

LOAD ..., Rangemax(Field1, Field2, Field3) as xxx

FROM ...

Fabrice


5 Replies
Not applicable

Re: How do I create another column in the same table that takes the max date from 3 other date columns

I would use the rangemax() function

LOAD ..., Rangemax(Field1, Field2, Field3) as xxx

FROM ...

Fabrice


jcharles
New Contributor III

Re: How do I create another column in the same table that takes the max date from 3 other date columns

I really appreciate the super quick response. It works !!!! Thank you.

Not applicable

Re: How do I create another column in the same table that takes the max date from 3 other date columns

Excellent,

Tag the answer as correct then

Fabrice

Not applicable

Re: How do I create another column in the same table that takes the max date from 3 other date columns

PFA

jcharles
New Contributor III

Re: How do I create another column in the same table that takes the max date from 3 other date columns

Thank you, that also works