topic Re: firstsortedvalue and concat in QlikView https://community.qlik.com/t5/QlikView/firstsortedvalue-and-concat/m-p/1251716#M396033 <HTML><HEAD></HEAD><BODY><P>Maybe something along is line?</P><P></P><P>concat(distinct IF(aggr(rank(count(Items),0,1),Customers)&lt;6,Customers))</P><P></P><P>Post a sample or qvw if that will not work.</P></BODY></HTML> Tue, 15 Nov 2016 13:51:03 GMT robert_mika 2016-11-15T13:51:03Z firstsortedvalue and concat https://community.qlik.com/t5/QlikView/firstsortedvalue-and-concat/m-p/1251714#M396031 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I want to show name of top 5 customers who recently have bought some items.</P><P>So the first function that come to my mind is to FirstSortedValue but it returns only 1 value at a time and i need to use it concat function to show 5 top customers.</P><P>Is there any solutions for it?</P><P>Regards,</P><P>Jean</P></BODY></HTML> Tue, 15 Nov 2016 12:37:16 GMT https://community.qlik.com/t5/QlikView/firstsortedvalue-and-concat/m-p/1251714#M396031 jduluc12 2016-11-15T12:37:16Z Re: firstsortedvalue and concat https://community.qlik.com/t5/QlikView/firstsortedvalue-and-concat/m-p/1251715#M396032 <HTML><HEAD></HEAD><BODY><P>May be use Rank function instead of FirstSortedValue() function here</P></BODY></HTML> Tue, 15 Nov 2016 12:39:53 GMT https://community.qlik.com/t5/QlikView/firstsortedvalue-and-concat/m-p/1251715#M396032 sunny_talwar 2016-11-15T12:39:53Z Re: firstsortedvalue and concat https://community.qlik.com/t5/QlikView/firstsortedvalue-and-concat/m-p/1251716#M396033 <HTML><HEAD></HEAD><BODY><P>Maybe something along is line?</P><P></P><P>concat(distinct IF(aggr(rank(count(Items),0,1),Customers)&lt;6,Customers))</P><P></P><P>Post a sample or qvw if that will not work.</P></BODY></HTML> Tue, 15 Nov 2016 13:51:03 GMT https://community.qlik.com/t5/QlikView/firstsortedvalue-and-concat/m-p/1251716#M396033 robert_mika 2016-11-15T13:51:03Z