Concat chart function make doubles

[lord_zeus]

Hello!

I have a problem with concat function. I'm try get string with top 4 countrys by sels in string with comma delimitr. 

But i need sort it to use SubField after in setAnalysis... so, if i dont use sort inside concat it work fine, but if i user sort expression function (concat) gives my not sort string + the same string sort...

What i do wrong?

[Anil_Babu_Samineni]

Perhaps this?

Match(country, $(=Concat(distinct {<country={"=Rank($(vDep))<5"}>} Chr(39) & country & chr(39))))

[lord_zeus]

This dont work for me... empty string return...

[Anil_Babu_Samineni]

What it is returning in Text box?

Concat(distinct {<country={"=Rank($(vDep))<5"}>} Chr(39) & country & chr(39))

[lord_zeus]

now i use in function subfield index 5,6,7,8... becouse 1,2,3,4 - not sorting string...bot im wont deal with the problem

[lord_zeus]

[Anil_Babu_Samineni]

Something this then?

Match(country, $(=Concat(distinct {<country={"=Rank($(vDep))<5"}>} Chr(39) & country & chr(39), Chr(44))))

[lord_zeus]

nop, epty string returns

[Anil_Babu_Samineni]

Where you are trying this? Is that something you are using in Sort expression?

[lord_zeus]

Im using in text area. Nothing special, something like Sum(sales)