topic Re: Opposite of FirstSortedValue in QlikView https://community.qlik.com/t5/QlikView/Opposite-of-FirstSortedValue/m-p/456901#M1161619 <HTML><HEAD></HEAD><BODY><P>The opposite is the firstsortedvalue too, only you put a - in front of the field/expression you want to sort on.</P><P>firstsortedvalue(Customer, Orderdate) gets the customer with the minumum orderdate</P><P>firstsortedvalue(Customer, -Orderdate) gets the customer with the maximum orderdate</P></BODY></HTML> Thu, 20 Dec 2012 13:34:17 GMT Gysbert_Wassenaar 2012-12-20T13:34:17Z Opposite of FirstSortedValue https://community.qlik.com/t5/QlikView/Opposite-of-FirstSortedValue/m-p/456900#M1161618 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>What is the exact opposite of FirstSotedValue i.e some thing like <EM><STRONG>LAST</STRONG></EM>SortedValue?</P><P></P><P>Thx</P><P>C</P></BODY></HTML> Thu, 20 Dec 2012 13:29:44 GMT https://community.qlik.com/t5/QlikView/Opposite-of-FirstSortedValue/m-p/456900#M1161618 2012-12-20T13:29:44Z Re: Opposite of FirstSortedValue https://community.qlik.com/t5/QlikView/Opposite-of-FirstSortedValue/m-p/456901#M1161619 <HTML><HEAD></HEAD><BODY><P>The opposite is the firstsortedvalue too, only you put a - in front of the field/expression you want to sort on.</P><P>firstsortedvalue(Customer, Orderdate) gets the customer with the minumum orderdate</P><P>firstsortedvalue(Customer, -Orderdate) gets the customer with the maximum orderdate</P></BODY></HTML> Thu, 20 Dec 2012 13:34:17 GMT https://community.qlik.com/t5/QlikView/Opposite-of-FirstSortedValue/m-p/456901#M1161619 Gysbert_Wassenaar 2012-12-20T13:34:17Z Re: Opposite of FirstSortedValue https://community.qlik.com/t5/QlikView/Opposite-of-FirstSortedValue/m-p/456902#M1161620 <HTML><HEAD></HEAD><BODY><P>use vlastsortedvalue</P></BODY></HTML> Thu, 20 Dec 2012 13:35:01 GMT https://community.qlik.com/t5/QlikView/Opposite-of-FirstSortedValue/m-p/456902#M1161620 er_mohit 2012-12-20T13:35:01Z