topic Pick max date row in QlikView https://community.qlik.com/t5/QlikView/Pick-max-date-row/m-p/1205188#M387479 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>My requirement is I need to pick only the rows with max-of-Date grouped by reqID.</P><P></P><P>Eg.</P><P>ReqID&nbsp; Status&nbsp; DateUpdated</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; open&nbsp;&nbsp;&nbsp; 5/10/2016</P><P><SPAN style="color: #00ccff;">1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WIP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6/10/2016</SPAN></P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; open&nbsp;&nbsp;&nbsp; 5/10/2016</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; closed&nbsp; 8/10/2016</P><P>-------</P><P></P><P>In this scenario , for&nbsp; ReqID=1, I need only one row i.e. highlighted in blue and followed by other.</P><P></P><P>Expected:</P><P style="font-size: 13.3333px;">ReqID&nbsp; Status&nbsp; DateUpdated</P><P style="font-size: 13.3333px;"><SPAN style="color: #00ccff;">1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WIP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6/10/2016</SPAN></P><P style="font-size: 13.3333px;">2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; open&nbsp;&nbsp;&nbsp;&nbsp; 5/10/2016</P><P style="font-size: 13.3333px;">3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; closed&nbsp;&nbsp; 8/10/2016</P><P style="font-size: 13.3333px;">-------</P><P></P><P>I cannot make any changes in Script.</P><P></P><P>Please suggest.</P><P></P><P>Thanks and Regards,</P><P>Priyanka</P></BODY></HTML> Wed, 19 Oct 2016 10:31:13 GMT priyankapassi 2016-10-19T10:31:13Z Pick max date row https://community.qlik.com/t5/QlikView/Pick-max-date-row/m-p/1205188#M387479 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>My requirement is I need to pick only the rows with max-of-Date grouped by reqID.</P><P></P><P>Eg.</P><P>ReqID&nbsp; Status&nbsp; DateUpdated</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; open&nbsp;&nbsp;&nbsp; 5/10/2016</P><P><SPAN style="color: #00ccff;">1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WIP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6/10/2016</SPAN></P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; open&nbsp;&nbsp;&nbsp; 5/10/2016</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; closed&nbsp; 8/10/2016</P><P>-------</P><P></P><P>In this scenario , for&nbsp; ReqID=1, I need only one row i.e. highlighted in blue and followed by other.</P><P></P><P>Expected:</P><P style="font-size: 13.3333px;">ReqID&nbsp; Status&nbsp; DateUpdated</P><P style="font-size: 13.3333px;"><SPAN style="color: #00ccff;">1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WIP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6/10/2016</SPAN></P><P style="font-size: 13.3333px;">2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; open&nbsp;&nbsp;&nbsp;&nbsp; 5/10/2016</P><P style="font-size: 13.3333px;">3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; closed&nbsp;&nbsp; 8/10/2016</P><P style="font-size: 13.3333px;">-------</P><P></P><P>I cannot make any changes in Script.</P><P></P><P>Please suggest.</P><P></P><P>Thanks and Regards,</P><P>Priyanka</P></BODY></HTML> Wed, 19 Oct 2016 10:31:13 GMT https://community.qlik.com/t5/QlikView/Pick-max-date-row/m-p/1205188#M387479 priyankapassi 2016-10-19T10:31:13Z Re: Pick max date row https://community.qlik.com/t5/QlikView/Pick-max-date-row/m-p/1205189#M387480 <HTML><HEAD></HEAD><BODY><P>You can use FirstSortedValue(Status, -DateUpdated) and FirstSortedValue(DateUpdated, -DateUpdated).&nbsp; I've attached an example file.</P></BODY></HTML> Wed, 19 Oct 2016 16:51:34 GMT https://community.qlik.com/t5/QlikView/Pick-max-date-row/m-p/1205189#M387480 Nicole-Smith 2016-10-19T16:51:34Z