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

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

jcharles — Tue, 04 Feb 2014 08:18:05 GMT

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 ID	Date Reported	Date Finalised	Date Closed	Date Converted
12345	29/10/2009	31/11/2013	02/02/2011
12346	23/05/2012	04/02/2014
12347	01/03/2013		14/06/2013
12348	22/01/2014			24/01/2014
12349	31/01/2014

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

Tue, 04 Feb 2014 08:21:59 GMT

I would use the rangemax() function

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

FROM ...

Fabrice

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

jcharles — Tue, 04 Feb 2014 08:46:02 GMT

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

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

Tue, 04 Feb 2014 08:48:30 GMT

Excellent,

Tag the answer as correct then

Fabrice

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

Tue, 04 Feb 2014 09:05:28 GMT

PFA

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

jcharles — Tue, 04 Feb 2014 10:11:18 GMT

Thank you, that also works