topic Re: Question on FirstSortedValue in QlikView https://community.qlik.com/t5/QlikView/Question-on-FirstSortedValue/m-p/698985#M1053944 <HTML><HEAD></HEAD><BODY><P>Nice, it's working - thx</P></BODY></HTML> Mon, 27 Oct 2014 05:58:52 GMT 2014-10-27T05:58:52Z Question on FirstSortedValue https://community.qlik.com/t5/QlikView/Question-on-FirstSortedValue/m-p/698983#M1053942 <HTML><HEAD></HEAD><BODY><P><IMG alt="FirstSortedValue.gif" class="jive-image" src="https://community.qlik.com/legacyfs/online/69717_FirstSortedValue.gif" style="width: 620px; height: 141px;" />I don't understand why set analysis is not working here, cfr gif which i added here</P></BODY></HTML> Mon, 27 Oct 2014 05:48:42 GMT https://community.qlik.com/t5/QlikView/Question-on-FirstSortedValue/m-p/698983#M1053942 2014-10-27T05:48:42Z Re: Question on FirstSortedValue https://community.qlik.com/t5/QlikView/Question-on-FirstSortedValue/m-p/698984#M1053943 <HTML><HEAD></HEAD><BODY><P>Try:</P><P>FirstSorteValue({&lt;Currency={'1EUR'}&gt;}Who, -Aggr(Sum(Amount),<STRONG>Currency</STRONG>,Who))</P></BODY></HTML> Mon, 27 Oct 2014 05:54:24 GMT https://community.qlik.com/t5/QlikView/Question-on-FirstSortedValue/m-p/698984#M1053943 tresB 2014-10-27T05:54:24Z Re: Question on FirstSortedValue https://community.qlik.com/t5/QlikView/Question-on-FirstSortedValue/m-p/698985#M1053944 <HTML><HEAD></HEAD><BODY><P>Nice, it's working - thx</P></BODY></HTML> Mon, 27 Oct 2014 05:58:52 GMT https://community.qlik.com/t5/QlikView/Question-on-FirstSortedValue/m-p/698985#M1053944 2014-10-27T05:58:52Z