Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
lord_zeus
Partner - Contributor III
Partner - Contributor III

Concat chart function make doubles

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...

2019-12-19 13_48_46-Window.png2019-12-19 13_49_07-Window.png2019-12-19 13_49_23-Window.png2019-12-19 13_49_32-Window.png

What i do wrong?

Labels (3)
17 Replies
lord_zeus
Partner - Contributor III
Partner - Contributor III
Author

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.

Anil_Babu_Samineni

@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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
lord_zeus
Partner - Contributor III
Partner - Contributor III
Author

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

lord_zeus
Partner - Contributor III
Partner - Contributor III
Author

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... 

lord_zeus
Partner - Contributor III
Partner - Contributor III
Author

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

Kushal_Chawda

may be this

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

lord_zeus
Partner - Contributor III
Partner - Contributor III
Author

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

Kushal_Chawda

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))