topic Show all values in country Dimension in QlikView https://community.qlik.com/t5/QlikView/Show-all-values-in-country-Dimension/m-p/69277#M11392 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>&nbsp; Please find the below table.Country dimension as list box if i selected ALL ,in the pivot table i want to show all countries except ALL&nbsp; otherwise it should show selected country.</P><TABLE width="128"><TBODY><TR><TD class="xl1539" height="17" width="64">country</TD><TD class="xl1539" width="64">Sales</TD></TR><TR><TD height="17">ALL</TD><TD align="right">40</TD></TR><TR><TD height="17">IND</TD><TD align="right">20</TD></TR><TR><TD height="17">USA</TD><TD align="right">10</TD></TR><TR><TD height="17">UK</TD><TD align="right">10</TD></TR></TBODY></TABLE></BODY></HTML> Tue, 22 May 2018 07:25:57 GMT Anonymous 2018-05-22T07:25:57Z Show all values in country Dimension https://community.qlik.com/t5/QlikView/Show-all-values-in-country-Dimension/m-p/69277#M11392 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>&nbsp; Please find the below table.Country dimension as list box if i selected ALL ,in the pivot table i want to show all countries except ALL&nbsp; otherwise it should show selected country.</P><TABLE width="128"><TBODY><TR><TD class="xl1539" height="17" width="64">country</TD><TD class="xl1539" width="64">Sales</TD></TR><TR><TD height="17">ALL</TD><TD align="right">40</TD></TR><TR><TD height="17">IND</TD><TD align="right">20</TD></TR><TR><TD height="17">USA</TD><TD align="right">10</TD></TR><TR><TD height="17">UK</TD><TD align="right">10</TD></TR></TBODY></TABLE></BODY></HTML> Tue, 22 May 2018 07:25:57 GMT https://community.qlik.com/t5/QlikView/Show-all-values-in-country-Dimension/m-p/69277#M11392 Anonymous 2018-05-22T07:25:57Z Re: Show all values in country Dimension https://community.qlik.com/t5/QlikView/Show-all-values-in-country-Dimension/m-p/69278#M11393 <HTML><HEAD></HEAD><BODY><P>Rather than adding ALL to the listbox, train your users so that they understand that clearing all selections is the same as selecting ALL.</P><P></P><P>And if that is a pivot table, check the partial totals option in Chart Properties | Presentation so QV calculates the total.</P></BODY></HTML> Tue, 22 May 2018 07:47:03 GMT https://community.qlik.com/t5/QlikView/Show-all-values-in-country-Dimension/m-p/69278#M11393 jonathandienst 2018-05-22T07:47:03Z