topic Re: More than 1 matching value with FirstSortedValue in QlikView https://community.qlik.com/t5/QlikView/More-than-1-matching-value-with-FirstSortedValue/m-p/531276#M198517 <HTML><HEAD></HEAD><BODY><P>Use this instead:</P><P></P><P>=Concat(distinct if(wkts=Max(total wkts),player),', ')</P><P></P><P>HIC</P></BODY></HTML> Thu, 05 Dec 2013 08:48:50 GMT hic 2013-12-05T08:48:50Z More than 1 matching value with FirstSortedValue https://community.qlik.com/t5/QlikView/More-than-1-matching-value-with-FirstSortedValue/m-p/531275#M198516 <HTML><HEAD></HEAD><BODY><P>My data is like this.</P><P></P><P>game:</P><P>load * inline</P><P>[</P><P>player, wkts</P><P>a, 20</P><P>b,30</P><P>c,20</P><P>d,30</P><P>e,41</P><P>f,41</P><P>];</P><P></P><P>Have a text box with this expression:</P><P>=FirstSortedValue(distinct player,-[wkts])</P><P></P><P>I get to see only Player 'e', where i want to see both e and f. Can you help please.</P></BODY></HTML> Thu, 05 Dec 2013 04:51:22 GMT https://community.qlik.com/t5/QlikView/More-than-1-matching-value-with-FirstSortedValue/m-p/531275#M198516 2013-12-05T04:51:22Z Re: More than 1 matching value with FirstSortedValue https://community.qlik.com/t5/QlikView/More-than-1-matching-value-with-FirstSortedValue/m-p/531276#M198517 <HTML><HEAD></HEAD><BODY><P>Use this instead:</P><P></P><P>=Concat(distinct if(wkts=Max(total wkts),player),', ')</P><P></P><P>HIC</P></BODY></HTML> Thu, 05 Dec 2013 08:48:50 GMT https://community.qlik.com/t5/QlikView/More-than-1-matching-value-with-FirstSortedValue/m-p/531276#M198517 hic 2013-12-05T08:48:50Z Re: More than 1 matching value with FirstSortedValue https://community.qlik.com/t5/QlikView/More-than-1-matching-value-with-FirstSortedValue/m-p/531277#M198518 <HTML><HEAD></HEAD><BODY><P>That is perfect.</P></BODY></HTML> Thu, 05 Dec 2013 22:40:33 GMT https://community.qlik.com/t5/QlikView/More-than-1-matching-value-with-FirstSortedValue/m-p/531277#M198518 2013-12-05T22:40:33Z