topic Re: max date distinct fields in QlikView

topic Re: max date distinct fields in QlikView https://community.qlik.com/t5/QlikView/max-date-distinct-fields/m-p/1832247#M1214654 <P>maybe like this:</P><P>date(Rangemax(DATE_1,DATE_2,DATE_3,DATE_4))</P> Mon, 30 Aug 2021 16:07:41 GMT Frank_Hartmann 2021-08-30T16:07:41Z max date distinct fields https://community.qlik.com/t5/QlikView/max-date-distinct-fields/m-p/1832240#M1214653 <P>hello everyone,</P><P>how is possible to get de max date between fields? </P><P>Example:</P><P> </P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Data Table</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>ID</TD><TD>DATE_1</TD><TD>DATE_2</TD><TD>DATE_3</TD><TD>DATE_4</TD><TD>Desired data</TD></TR><TR><TD>1</TD><TD>30/4/2021</TD><TD>10/5/2021</TD><TD>5/7/2021</TD><TD>4/8/2021</TD><TD>4/8/2021</TD></TR><TR><TD>2</TD><TD>20/4/2021</TD><TD>13/5/2021</TD><TD>11/6/2021</TD><TD>23/6/2021</TD><TD>23/6/2021</TD></TR><TR><TD>3</TD><TD>14/8/2021</TD><TD>26/8/2021</TD><TD>17/5/2021</TD><TD>22/7/2021</TD><TD>26/8/2021</TD></TR><TR><TD>4</TD><TD>29/4/2021</TD><TD>11/7/2021</TD><TD>27/5/2021</TD><TD>10/6/2021</TD><TD>11/7/2021</TD></TR><TR><TD>5</TD><TD>12/2/2021</TD><TD>23/4/2021</TD><TD>12/2/2021</TD><TD>30/6/2021</TD><TD>30/6/2021</TD></TR></TBODY></TABLE> Mon, 30 Aug 2021 15:47:04 GMT https://community.qlik.com/t5/QlikView/max-date-distinct-fields/m-p/1832240#M1214653 tincholiver 2021-08-30T15:47:04Z Re: max date distinct fields https://community.qlik.com/t5/QlikView/max-date-distinct-fields/m-p/1832247#M1214654 <P>maybe like this:</P><P>date(Rangemax(DATE_1,DATE_2,DATE_3,DATE_4))</P> Mon, 30 Aug 2021 16:07:41 GMT https://community.qlik.com/t5/QlikView/max-date-distinct-fields/m-p/1832247#M1214654 Frank_Hartmann 2021-08-30T16:07:41Z Re: max date distinct fields https://community.qlik.com/t5/QlikView/max-date-distinct-fields/m-p/1832248#M1214655 <P>very good! </P><P>thank you <a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/29675">@Frank_Hartmann</a> </P> Mon, 30 Aug 2021 16:12:36 GMT https://community.qlik.com/t5/QlikView/max-date-distinct-fields/m-p/1832248#M1214655 tincholiver 2021-08-30T16:12:36Z