topic Re: Top Country Selection in QlikView https://community.qlik.com/t5/QlikView/Top-Country-Selection/m-p/1044199#M942164 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Uncheck show others option.</P><P></P><P>Regards,</P><P>jagan.</P></BODY></HTML> Thu, 21 Jan 2016 09:04:18 GMT jagan 2016-01-21T09:04:18Z Top Country Selection https://community.qlik.com/t5/QlikView/Top-Country-Selection/m-p/1044198#M942163 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P>In my dashboard we are showing top coutries like 1. Top 20 2. Top 50 and 3. Show all in Buttons once user select on for ex top 20 then accordingly coutries will displays in straight table. For that we are using variable and Dimension limits option in straight table like below.</P><P><IMG alt="Dimension limits.PNG" class="jive-image image-1" src="/legacyfs/online/112190_Dimension limits.PNG" style="height: auto;" /></P><P></P><P>for Show all - variable is =Count({1} RISK_COUNTRY_ORIGINAL)</P><P></P><P>here my issue is when ever user selects for top 20 then it displays 19 + others</P><P></P><P>Others = rest of countries</P><P></P><P>For ex</P><P>we have 50 countries and user selects top 20 so here 19 countries and 31 would be others like below.</P><P><IMG alt="Others.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/112191_Others.PNG" style="height: auto;" /></P><P>Dimension is like above and expression we have many.</P><P></P><P>Here Others shouldn't display it should display top as per selection</P><P></P><P>- thank you</P></BODY></HTML> Thu, 21 Jan 2016 09:01:06 GMT https://community.qlik.com/t5/QlikView/Top-Country-Selection/m-p/1044198#M942163 priyarane 2016-01-21T09:01:06Z Re: Top Country Selection https://community.qlik.com/t5/QlikView/Top-Country-Selection/m-p/1044199#M942164 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Uncheck show others option.</P><P></P><P>Regards,</P><P>jagan.</P></BODY></HTML> Thu, 21 Jan 2016 09:04:18 GMT https://community.qlik.com/t5/QlikView/Top-Country-Selection/m-p/1044199#M942164 jagan 2016-01-21T09:04:18Z Re: Top Country Selection https://community.qlik.com/t5/QlikView/Top-Country-Selection/m-p/1044200#M942165 <HTML><HEAD></HEAD><BODY><P>hi</P><P><IMG alt="shw.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/112188_shw.png" style="height: auto;" /></P></BODY></HTML> Thu, 21 Jan 2016 09:07:44 GMT https://community.qlik.com/t5/QlikView/Top-Country-Selection/m-p/1044200#M942165 Chanty4u 2016-01-21T09:07:44Z