topic Re: How to return the latest status per Project based on date in QlikView https://community.qlik.com/t5/QlikView/How-to-return-the-latest-status-per-Project-based-on-date/m-p/418876#M1161211 <HTML><HEAD></HEAD><BODY><P>Thanks!</P></BODY></HTML> Fri, 09 Nov 2012 10:05:39 GMT 2012-11-09T10:05:39Z How to return the latest status per Project based on date https://community.qlik.com/t5/QlikView/How-to-return-the-latest-status-per-Project-based-on-date/m-p/418874#M1161209 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have a list of Projects with the status of each project at a certain point in time. What I would like to do is create a straight table that shows the <STRONG>latest </STRONG>status per project, ie something like:</P><P></P><P></P><P> <IMG __jive_id="24854" class="jive-image" alt="LatestStatus.JPG" src="https://community.qlik.com/legacyfs/online/24854_LatestStatus.JPG" /></P><P></P><P></P><P>Thanks for you help</P><P></P><P></P><P><SPAN style="color: #339966;">Sample data:</SPAN></P><P></P><P>Load</P><P><SPAN style="font-size: 8pt;"> *<BR /><BR /></SPAN><SPAN style="color: #0000ff; font-size: 8pt;">INLINE</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">[<BR /><BR />&nbsp;&nbsp;&nbsp; ProjectID, StatusDate, Status<BR /><BR />&nbsp;&nbsp;&nbsp; P1, 2012/01/01, Active<BR /><BR />&nbsp;&nbsp;&nbsp; P1, 2012/01/20, on Hold<BR /><BR />&nbsp;&nbsp;&nbsp; P1, 2012/02/15, Discontinued<BR /><BR />&nbsp;&nbsp;&nbsp; P2, 2012/01/05, Active<BR /><BR />&nbsp;&nbsp;&nbsp; P2, 2012/01/07, on Hold<BR /><BR />&nbsp;&nbsp;&nbsp; P3, 2012/01/02, Active<BR /><BR />&nbsp;&nbsp;&nbsp; P3, 2012/01/09, Discontinued<BR /><BR />]</SPAN><SPAN style="font-size: 8pt;">; </SPAN></P></BODY></HTML> Fri, 09 Nov 2012 05:28:47 GMT https://community.qlik.com/t5/QlikView/How-to-return-the-latest-status-per-Project-based-on-date/m-p/418874#M1161209 2012-11-09T05:28:47Z Re: How to return the latest status per Project based on date https://community.qlik.com/t5/QlikView/How-to-return-the-latest-status-per-Project-based-on-date/m-p/418875#M1161210 <HTML><HEAD></HEAD><BODY><P>Use ProjectID as dimension and create two expressions:</P><P>aggr(firstsortedvalue(StatusDate, -StatusDate),ProjectID)</P><P>aggr(firstsortedvalue(Status, -StatusDate),ProjectID)</P></BODY></HTML> Fri, 09 Nov 2012 09:48:42 GMT https://community.qlik.com/t5/QlikView/How-to-return-the-latest-status-per-Project-based-on-date/m-p/418875#M1161210 Gysbert_Wassenaar 2012-11-09T09:48:42Z Re: How to return the latest status per Project based on date https://community.qlik.com/t5/QlikView/How-to-return-the-latest-status-per-Project-based-on-date/m-p/418876#M1161211 <HTML><HEAD></HEAD><BODY><P>Thanks!</P></BODY></HTML> Fri, 09 Nov 2012 10:05:39 GMT https://community.qlik.com/t5/QlikView/How-to-return-the-latest-status-per-Project-based-on-date/m-p/418876#M1161211 2012-11-09T10:05:39Z