topic Exclude Option from a ListBox in QlikView https://community.qlik.com/t5/QlikView/Exclude-Option-from-a-ListBox/m-p/362242#M493227 <HTML><HEAD></HEAD><BODY><P>If I have a field/listbox with 5 unique options, and I want to exclude showing one of them (not necessarily a null, just a value I don't want to provide as a filter option) - what is the easiest way to do that?</P></BODY></HTML> Mon, 21 May 2012 22:18:21 GMT sspringer 2012-05-21T22:18:21Z Exclude Option from a ListBox https://community.qlik.com/t5/QlikView/Exclude-Option-from-a-ListBox/m-p/362242#M493227 <HTML><HEAD></HEAD><BODY><P>If I have a field/listbox with 5 unique options, and I want to exclude showing one of them (not necessarily a null, just a value I don't want to provide as a filter option) - what is the easiest way to do that?</P></BODY></HTML> Mon, 21 May 2012 22:18:21 GMT https://community.qlik.com/t5/QlikView/Exclude-Option-from-a-ListBox/m-p/362242#M493227 sspringer 2012-05-21T22:18:21Z Exclude Option from a ListBox https://community.qlik.com/t5/QlikView/Exclude-Option-from-a-ListBox/m-p/362243#M493228 <HTML><HEAD></HEAD><BODY><P>Select &lt;expression&gt; from the field drop down list in the list box properties and enter</P><P></P><P><EM>=if(FIELD &lt;&gt; 'DontWantThisValue', FIELD)</EM></P></BODY></HTML> Mon, 21 May 2012 22:25:24 GMT https://community.qlik.com/t5/QlikView/Exclude-Option-from-a-ListBox/m-p/362243#M493228 swuehl 2012-05-21T22:25:24Z