topic Re: aggr in QlikView https://community.qlik.com/t5/QlikView/aggr/m-p/544815#M551178 <HTML><HEAD></HEAD><BODY><P>Hi Guys</P><P></P><P>you're all right.</P><P>I was just deep inside aggr function. I will therefore remember this one</P><P></P><P>thank you, </P><P>Chris</P></BODY></HTML> Mon, 09 Dec 2013 14:47:13 GMT 2013-12-09T14:47:13Z aggr https://community.qlik.com/t5/QlikView/aggr/m-p/544811#M551174 <HTML><HEAD></HEAD><BODY><P>Hi everybody</P><P></P><P>I've a little aggr issue to solve</P><P></P><P>Some people have 2 status. When there are different i can't display the last one.</P><P></P><P>Ex :</P><P>Name&nbsp;&nbsp;&nbsp;&nbsp; Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Status</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2/11/13&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; open</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2/12/13&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; stand by</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5/11/13&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; open</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2/12/13&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; open</P><P></P><P>What i get is</P><P>Name&nbsp;&nbsp;&nbsp;&nbsp; Status</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; open</P><P></P><P>and I'd like to get Status Stand by for A</P><P>I tried to aggregate on max(date) but it didn't work</P><P></P><P>Thank you for your help</P><P>Chris</P></BODY></HTML> Mon, 09 Dec 2013 10:04:48 GMT https://community.qlik.com/t5/QlikView/aggr/m-p/544811#M551174 2013-12-09T10:04:48Z Re: aggr https://community.qlik.com/t5/QlikView/aggr/m-p/544812#M551175 <HTML><HEAD></HEAD><BODY><P>USE STRAIGHT TABLE</P><P>Dimension = Name</P><P>Expression = <SPAN style="font-size: 8pt;">FIRSTSORTEDVALUE(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Status</SPAN><SPAN style="font-size: 8pt;">, -</SPAN><SPAN style="color: #800000; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P></P></BODY></HTML> Mon, 09 Dec 2013 10:09:56 GMT https://community.qlik.com/t5/QlikView/aggr/m-p/544812#M551175 MK_QSL 2013-12-09T10:09:56Z Re: aggr https://community.qlik.com/t5/QlikView/aggr/m-p/544813#M551176 <HTML><HEAD></HEAD><BODY><P>Christian,</P><P></P><P>Did you try FirstSortedValue ?</P><P>FirstSortedValue(Status, -Date)</P><P></P><P>Fabrice</P></BODY></HTML> Mon, 09 Dec 2013 10:12:04 GMT https://community.qlik.com/t5/QlikView/aggr/m-p/544813#M551176 2013-12-09T10:12:04Z Re: aggr https://community.qlik.com/t5/QlikView/aggr/m-p/544814#M551177 <HTML><HEAD></HEAD><BODY><P>PFA</P></BODY></HTML> Mon, 09 Dec 2013 10:12:06 GMT https://community.qlik.com/t5/QlikView/aggr/m-p/544814#M551177 tresB 2013-12-09T10:12:06Z Re: aggr https://community.qlik.com/t5/QlikView/aggr/m-p/544815#M551178 <HTML><HEAD></HEAD><BODY><P>Hi Guys</P><P></P><P>you're all right.</P><P>I was just deep inside aggr function. I will therefore remember this one</P><P></P><P>thank you, </P><P>Chris</P></BODY></HTML> Mon, 09 Dec 2013 14:47:13 GMT https://community.qlik.com/t5/QlikView/aggr/m-p/544815#M551178 2013-12-09T14:47:13Z Re: aggr https://community.qlik.com/t5/QlikView/aggr/m-p/544816#M551179 <HTML><HEAD></HEAD><BODY><P>Wellcome Christian,</P><P>I think you can also use it with the LOAD statement (and GROUP BY)</P><P></P><P>Fabrice</P></BODY></HTML> Mon, 09 Dec 2013 15:13:54 GMT https://community.qlik.com/t5/QlikView/aggr/m-p/544816#M551179 2013-12-09T15:13:54Z