topic Re: Exclude selected values in QlikView https://community.qlik.com/t5/QlikView/Exclude-selected-values/m-p/534290#M199583 <HTML><HEAD></HEAD><BODY><P>You can select the single value in the listbox and then right click the listbox and choose Select Excluded to invert the selection. To make it easier to select multiple values you can choose a checkbox style on the Presentation tab for Selection Style Override.</P><P></P><P>If you're using QV11 you could also create an alternate state for the listbox. You can then select the exceptions in that listbox. You'll need to change the chart expression to make use of the alternate state. For example if you have an expression count(Amount) that would become count({$-[AltStateName]} Amount)</P></BODY></HTML> Mon, 28 Oct 2013 11:53:26 GMT Gysbert_Wassenaar 2013-10-28T11:53:26Z Exclude selected values https://community.qlik.com/t5/QlikView/Exclude-selected-values/m-p/534289#M199582 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>is there a possibility to exclude single values. Look at this chart:</P><P></P><P><IMG alt="qv_chart.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/48214_qv_chart.jpg" style="width: 620px; height: 401px;" /></P><P>I would like to give the users the opportunity to exclude for example this value(via listbox for example). This would make it much easier to read the chart. I don't want to "hardcode" something because its necessary to see those extraordinary values too.</P><P></P><P>Best Regards,</P><P></P><P>Peter</P></BODY></HTML> Mon, 28 Oct 2013 09:17:57 GMT https://community.qlik.com/t5/QlikView/Exclude-selected-values/m-p/534289#M199582 peschu123 2013-10-28T09:17:57Z Re: Exclude selected values https://community.qlik.com/t5/QlikView/Exclude-selected-values/m-p/534290#M199583 <HTML><HEAD></HEAD><BODY><P>You can select the single value in the listbox and then right click the listbox and choose Select Excluded to invert the selection. To make it easier to select multiple values you can choose a checkbox style on the Presentation tab for Selection Style Override.</P><P></P><P>If you're using QV11 you could also create an alternate state for the listbox. You can then select the exceptions in that listbox. You'll need to change the chart expression to make use of the alternate state. For example if you have an expression count(Amount) that would become count({$-[AltStateName]} Amount)</P></BODY></HTML> Mon, 28 Oct 2013 11:53:26 GMT https://community.qlik.com/t5/QlikView/Exclude-selected-values/m-p/534290#M199583 Gysbert_Wassenaar 2013-10-28T11:53:26Z