How find the latest date among others from different columns

[Maciej29]

Hello, I'm looking for solution for issue with searching the latest date. I thought about calculated field. In excel i used formula MAX with indicated range. How can I handle it in qlik sense  ? In my example I need to find proper,the latest date.

Thank you in advance for every tip.

[Or · Accepted solution]

Date(RangeMax(Field1,Field2,...))

[Saravanan_Desingh]

One solution is.

tab1:
LOAD * INLINE [
    Doc, Date Created, Date First Touch, Date Approval, Date Verification
    67978653, 5/10/2020, 5/12/2020, 5/13/2020, 
    45557667, 5/8/2020, 5/13/2020, , 
    11223235, 5/10/2020, 5/17/2020, 5/22/2020, 5/25/2020
    68999061, 5/11/2020, , , 
];

tab1X:
CrossTable(Hdr, Dates)
LOAD * Resident tab1;

Left Join(tab1)
LOAD Doc, Date(Max(Dates)) As [Latest Date]
Resident tab1X
Group By Doc;

Drop Table tab1X;

[Saravanan_Desingh]

[Maciej29]

Saran7de, 

Thank you, but i'm not sure if can do it ,cause i'm not familiar with script using. 

[Saravanan_Desingh]

ok sure