topic Re: How can i get a single row in QlikView https://community.qlik.com/t5/QlikView/How-can-i-get-a-single-row/m-p/419813#M486457 <HTML><HEAD></HEAD><BODY><P>It is easy to implement using FirstSortedValue() function:</P><P><STRONG>=FirstSortedValue(NAME, -SALES) </STRONG></P><P></P><P>Regards,<BR />Michael</P></BODY></HTML> Wed, 03 Apr 2013 19:24:16 GMT Anonymous 2013-04-03T19:24:16Z How can i get a single row https://community.qlik.com/t5/QlikView/How-can-i-get-a-single-row/m-p/419812#M486456 <HTML><HEAD></HEAD><BODY><P>Please,</P><P>How can i get a single row in a list of sellers, I want show the best seller.</P><P></P><P>Example:</P><P></P><P>NAME - SALES</P><P>Rodrigo - 500</P><P>Bruno - 300</P><P>Lucas - 7000</P><P></P><P>I wanna show only Lucas in a Text Object.</P><P></P><P>Somebody can help me please??</P></BODY></HTML> Wed, 03 Apr 2013 18:25:04 GMT https://community.qlik.com/t5/QlikView/How-can-i-get-a-single-row/m-p/419812#M486456 2013-04-03T18:25:04Z Re: How can i get a single row https://community.qlik.com/t5/QlikView/How-can-i-get-a-single-row/m-p/419813#M486457 <HTML><HEAD></HEAD><BODY><P>It is easy to implement using FirstSortedValue() function:</P><P><STRONG>=FirstSortedValue(NAME, -SALES) </STRONG></P><P></P><P>Regards,<BR />Michael</P></BODY></HTML> Wed, 03 Apr 2013 19:24:16 GMT https://community.qlik.com/t5/QlikView/How-can-i-get-a-single-row/m-p/419813#M486457 Anonymous 2013-04-03T19:24:16Z Re: How can i get a single row https://community.qlik.com/t5/QlikView/How-can-i-get-a-single-row/m-p/419814#M486458 <HTML><HEAD></HEAD><BODY><P>Try this, It must work.</P><P></P><P>=Only({&lt;SALES={"$(=Max(SALES))"}&gt;}NAME)</P></BODY></HTML> Thu, 04 Apr 2013 08:44:59 GMT https://community.qlik.com/t5/QlikView/How-can-i-get-a-single-row/m-p/419814#M486458 manideep78 2013-04-04T08:44:59Z