topic Re: Firstsortedvalue in QlikView https://community.qlik.com/t5/QlikView/Firstsortedvalue/m-p/705381#M254300 <HTML><HEAD></HEAD><BODY><P>Thanks this worked!</P></BODY></HTML> Tue, 19 Aug 2014 13:25:47 GMT rustyfishbones 2014-08-19T13:25:47Z Firstsortedvalue https://community.qlik.com/t5/QlikView/Firstsortedvalue/m-p/705374#M254293 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have the following expression that should return the name of the Bowler with the most wickets taken, however 2 Bowlers have the same amount, how can I show both names as the shared top Wicket taker</P><P></P><P>='Leading Wkt Taker '&amp; chr(13) &amp;</P><P></P><P></P><P>FirstSortedValue(Bowler,-Aggr(SUM(Wickets),Bowler))</P><P></P><P></P><P>&amp; ' ' &amp; MAX(AGGR(SUM(Wickets),Bowler))</P></BODY></HTML> Tue, 19 Aug 2014 12:18:40 GMT https://community.qlik.com/t5/QlikView/Firstsortedvalue/m-p/705374#M254293 rustyfishbones 2014-08-19T12:18:40Z Re: Firstsortedvalue https://community.qlik.com/t5/QlikView/Firstsortedvalue/m-p/705375#M254294 <HTML><HEAD></HEAD><BODY><P>Maybe you could integrate rank() or/and concat() in your firstsortedvalue-expression.</P><P></P><P>- Marcus</P></BODY></HTML> Tue, 19 Aug 2014 12:26:20 GMT https://community.qlik.com/t5/QlikView/Firstsortedvalue/m-p/705375#M254294 marcus_sommer 2014-08-19T12:26:20Z Re: Firstsortedvalue https://community.qlik.com/t5/QlikView/Firstsortedvalue/m-p/705376#M254295 <HTML><HEAD></HEAD><BODY><P>You may need to add nodistinct to your aggr functions. Aggr(nodistinct SUM(Wickets),Bowler))</P></BODY></HTML> Tue, 19 Aug 2014 12:32:50 GMT https://community.qlik.com/t5/QlikView/Firstsortedvalue/m-p/705376#M254295 2014-08-19T12:32:50Z Re: Firstsortedvalue https://community.qlik.com/t5/QlikView/Firstsortedvalue/m-p/705377#M254296 <HTML><HEAD></HEAD><BODY><P>I tried that, no luck....</P></BODY></HTML> Tue, 19 Aug 2014 12:38:43 GMT https://community.qlik.com/t5/QlikView/Firstsortedvalue/m-p/705377#M254296 rustyfishbones 2014-08-19T12:38:43Z Re: Firstsortedvalue https://community.qlik.com/t5/QlikView/Firstsortedvalue/m-p/705378#M254297 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P>Load * Inline [</P> <P>Dim, Amt</P> <P>A, 100</P> <P>B, 100</P> <P>C, 99</P> <P>D, 98]</P> </TD></TR></TBODY></TABLE></BLOCKQUOTE><P>=FirstSortedValue( Aggr(Concat(Dim,','),Amt),-Aggr(Amt,Amt))</P><P></P><P><STRONG>Gives - A,B</STRONG></P></BODY></HTML> Tue, 19 Aug 2014 12:39:31 GMT https://community.qlik.com/t5/QlikView/Firstsortedvalue/m-p/705378#M254297 tresB 2014-08-19T12:39:31Z Re: Firstsortedvalue https://community.qlik.com/t5/QlikView/Firstsortedvalue/m-p/705379#M254298 <HTML><HEAD></HEAD><BODY><P>Tried it with Rank and Concat, but I could not get it working</P></BODY></HTML> Tue, 19 Aug 2014 12:40:22 GMT https://community.qlik.com/t5/QlikView/Firstsortedvalue/m-p/705379#M254298 rustyfishbones 2014-08-19T12:40:22Z Re: Firstsortedvalue https://community.qlik.com/t5/QlikView/Firstsortedvalue/m-p/705380#M254299 <HTML><HEAD></HEAD><BODY><P>Maybe:</P><P></P><P><STRONG>concat({&lt;Bowler = {'=rank(sum(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Wickets)</SPAN>)=1'}&gt;}distinct Bowler, ',')</STRONG></P><P></P><P>Hope this helps!</P></BODY></HTML> Tue, 19 Aug 2014 13:11:53 GMT https://community.qlik.com/t5/QlikView/Firstsortedvalue/m-p/705380#M254299 jerem1234 2014-08-19T13:11:53Z Re: Firstsortedvalue https://community.qlik.com/t5/QlikView/Firstsortedvalue/m-p/705381#M254300 <HTML><HEAD></HEAD><BODY><P>Thanks this worked!</P></BODY></HTML> Tue, 19 Aug 2014 13:25:47 GMT https://community.qlik.com/t5/QlikView/Firstsortedvalue/m-p/705381#M254300 rustyfishbones 2014-08-19T13:25:47Z