Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
pablomind
Creator
Creator

Other Segment its showing wrong result in Grid Chart

Hello everybody,

I'd been struggling the last few days with this problem. I have a Grid Chart with two dimensions (Country and Segment) and also have one expression: 

COUNT (DISTINCT {<[Client ID] = P ({<ID={00922}>} [Client ID] ) >*<[Client ID] = P ({<ID={00874}>} [Client ID] ) > } [Client ID])

Which count every client ID which exits for 00922 and 00874 at the same time and it works perfectly. I need the Top 5 Countries and also the Top 5 Segments from those countries, I do this with the Dimension Limit Tab; in this tab I checked the Show Other Option so I can see the rest of the countries if I need to. But the problem is how to get the Other information correctly. I cant click on the Other label name (Otros in spanish) and when I click on the bubble of Other for one country for example the first country:

Grid Chart 1.PNG

I only get info of the first segment that I already had previosly on the Top 5 and its not showing me the rest of the segments like its supposed to:

Grid Chart 2.PNG

Any answer for this problem?

Regards,

Pablo

 
Labels (4)
1 Reply
Brett_Bleess
Employee
Employee

Not sure, but have a look at the following two Design Blog posts, they may give you another option:

https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-a-Pareto-Analysis/ba-p/1468497

https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-a-Pareto-Analysis-Revisited/ba-p/1473684

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.