topic Re: Max(Date) from two fields in QlikView https://community.qlik.com/t5/QlikView/Max-Date-from-two-fields/m-p/376600#M491764 <HTML><HEAD></HEAD><BODY><P>Hey,</P><P>You could try something like</P><P>rangemax(aggr(max([<SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">Posting date]</SPAN>),[<SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">Item No</SPAN>]),aggr(max([Posting date]),[Lot No]))</P><P></P><P>Hope that helps,</P><P></P><P>Frank</P></BODY></HTML> Thu, 09 Aug 2012 12:48:32 GMT 2012-08-09T12:48:32Z Max(Date) from two fields https://community.qlik.com/t5/QlikView/Max-Date-from-two-fields/m-p/376599#M491763 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I have one requirement where,there are three fields into one table viz.Item No ,Lot No. &amp; posting date</P><P>Item No&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Lot No&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Posting date</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 08/08/2012</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 07/08/2012</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 04/08/2012</P><P>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 09/08/2012</P><P></P><P></P><P>so Max(Date) for A will be 08/08/2012</P><P>&amp; Max(Date) for A1 will be 09/08/2012</P><P></P><P> when I will select A &amp; A1 It will show Max(Date) =09/08/2012</P><P></P><P>How can I achieve this?</P><P></P><P>Thanx</P></BODY></HTML> Thu, 09 Aug 2012 11:13:18 GMT https://community.qlik.com/t5/QlikView/Max-Date-from-two-fields/m-p/376599#M491763 2012-08-09T11:13:18Z Re: Max(Date) from two fields https://community.qlik.com/t5/QlikView/Max-Date-from-two-fields/m-p/376600#M491764 <HTML><HEAD></HEAD><BODY><P>Hey,</P><P>You could try something like</P><P>rangemax(aggr(max([<SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">Posting date]</SPAN>),[<SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">Item No</SPAN>]),aggr(max([Posting date]),[Lot No]))</P><P></P><P>Hope that helps,</P><P></P><P>Frank</P></BODY></HTML> Thu, 09 Aug 2012 12:48:32 GMT https://community.qlik.com/t5/QlikView/Max-Date-from-two-fields/m-p/376600#M491764 2012-08-09T12:48:32Z Re: Max(Date) from two fields https://community.qlik.com/t5/QlikView/Max-Date-from-two-fields/m-p/376601#M491765 <HTML><HEAD></HEAD><BODY><P>Thanx frankcrezee for your timely &amp; correct response.It helps me to achieve what I wanted.</P></BODY></HTML> Fri, 10 Aug 2012 04:38:04 GMT https://community.qlik.com/t5/QlikView/Max-Date-from-two-fields/m-p/376601#M491765 2012-08-10T04:38:04Z