topic Re: Concat chart function make doubles in App Development

Concat chart function make doubles

lord_zeus — Sat, 16 Nov 2024 19:25:15 GMT

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?

Re: Concat chart function make doubles

Anil_Babu_Samineni — Thu, 19 Dec 2019 11:00:16 GMT

Perhaps this?

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

Re: Concat chart function make doubles

lord_zeus — Thu, 19 Dec 2019 11:12:04 GMT

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

Re: Concat chart function make doubles

Anil_Babu_Samineni — Thu, 19 Dec 2019 11:13:21 GMT

What it is returning in Text box?

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

Re: Concat chart function make doubles

lord_zeus — Thu, 19 Dec 2019 11:15:38 GMT

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

Re: Concat chart function make doubles

lord_zeus — Thu, 19 Dec 2019 11:16:35 GMT

Re: Concat chart function make doubles

Anil_Babu_Samineni — Thu, 19 Dec 2019 11:18:51 GMT

Something this then?

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

Re: Concat chart function make doubles

lord_zeus — Thu, 19 Dec 2019 11:25:25 GMT

nop, epty string returns

Re: Concat chart function make doubles

Anil_Babu_Samineni — Thu, 19 Dec 2019 11:27:55 GMT

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

Re: Concat chart function make doubles

lord_zeus — Thu, 19 Dec 2019 11:43:49 GMT

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

Re: Concat chart function make doubles

lord_zeus — Thu, 16 Jan 2020 13:03:42 GMT

The branch is still relevant!

I got out of the situation simply using the formula n + k, where n - varies from 1 to n of my measurement options, and 'x' is the maximum number.

Re: Concat chart function make doubles

Anil_Babu_Samineni — Fri, 17 Jan 2020 09:20:40 GMT

@lord_zeus If that resolved, please mark yourself as correct answer with solution. If not resolved yet, Kindly share some sample data set and outcome

Re: Concat chart function make doubles

lord_zeus — Fri, 17 Jan 2020 14:30:35 GMT

No, it still not resolved. In still have this problem. Example in att

Re: Concat chart function make doubles

lord_zeus — Fri, 17 Jan 2020 15:08:12 GMT

im finde some kinde of solution but, im dont understand why it work like that:

so if we have table with 'countrys' and we wont make a list with 3-4 top by sales in country we will have result like me. But, if we have a referance book ( directory) with unicu list of countrys ( in fact table we will have 1000 records, but in country table we have 10 unical rows with keys to fact), and make concat by this tables of countrys and make rank by sales in fact - everithing will by fine, and im have no doubles in result list after concat with sort.

Why it happends im dont know...

Re: Concat chart function make doubles

lord_zeus — Fri, 17 Jan 2020 15:09:19 GMT

Im wont to finde solution without need to add new table in model.... it is possible?

Re: Concat chart function make doubles

Kushal_Chawda — Fri, 17 Jan 2020 15:42:22 GMT

may be this

Concat({<Country = {"=Rank( Sum( Sale))<3"}>} distinct Country,', ', -aggr(nodistinct Sum(Sale),Country))

Re: Concat chart function make doubles

lord_zeus — Fri, 17 Jan 2020 15:49:44 GMT

@Kushal_Chawda yes, its work! Any explane of this? why did you decide to use nodistinct?

Re: Concat chart function make doubles

Kushal_Chawda — Fri, 17 Jan 2020 16:21:24 GMT

I think @hic @rwunderlich can give you better insight. What I am thinking this is happening because of set analysis. If I use rank function with simple if statement it works. Here I don't need to use any qualifier like distinct or nodistinct

=Concat(aggr(if(Rank(Sum( Sale))<3,Country),Country),',', -aggr(sum(Sale),Country))