Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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

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?



Labels (4)
1 Reply

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




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.