Other Segment its showing wrong result in Grid Chart

pablomind — Sat, 16 Nov 2024 18:51:21 GMT

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:

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:

Any answer for this problem?

Regards,

Pablo

Re: Other Segment its showing wrong result in Grid Chart

Brett_Bleess — Wed, 22 Apr 2020 21:22:12 GMT

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

topic Other Segment its showing wrong result in Grid Chart in QlikView

Other Segment its showing wrong result in Grid Chart

Re: Other Segment its showing wrong result in Grid Chart