firstsortedvalue and concat

[jduluc12]

Hi

I want to show name of top 5 customers who recently have bought some items.

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.

Is there any solutions for it?

Regards,

Jean

[sunny_talwar]

May be use Rank function instead of FirstSortedValue() function here

[robert_mika]

Maybe something along is line?

concat(distinct IF(aggr(rank(count(Items),0,1),Customers)<6,Customers))

Post a sample or qvw if that will not work.