topic Re: Eliminating field value in QlikView https://community.qlik.com/t5/QlikView/Eliminating-field-value/m-p/559757#M1140594 <HTML><HEAD></HEAD><BODY><P>Try expression for the list box, expression:</P><P></P><P>=If(Region&lt;&gt;'Atlanta', Region)</P></BODY></HTML> Tue, 24 Sep 2013 14:26:42 GMT tresB 2013-09-24T14:26:42Z Eliminating field value https://community.qlik.com/t5/QlikView/Eliminating-field-value/m-p/559754#M1140591 <HTML><HEAD></HEAD><BODY><P>I have a field called region with different region names.In regions I have Atlanta,Floroda,washington etc.I dont want to display Atlanta in that Region list box.How can I do this ?Please help me.</P><P></P><P>Thanks in advance.</P></BODY></HTML> Tue, 24 Sep 2013 11:53:27 GMT https://community.qlik.com/t5/QlikView/Eliminating-field-value/m-p/559754#M1140591 2013-09-24T11:53:27Z Re: Eliminating field value https://community.qlik.com/t5/QlikView/Eliminating-field-value/m-p/559755#M1140592 <HTML><HEAD></HEAD><BODY><P>On the general tab of List Box Properties, select &lt;Expression&gt; in the field drop down. Use this expression to exclude Atlanta (assuming your field is named "Region"):</P><P></P><P>=if(Region='Atlanta',null(),Region)</P></BODY></HTML> Tue, 24 Sep 2013 14:01:40 GMT https://community.qlik.com/t5/QlikView/Eliminating-field-value/m-p/559755#M1140592 2013-09-24T14:01:40Z Re: Eliminating field value https://community.qlik.com/t5/QlikView/Eliminating-field-value/m-p/559756#M1140593 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Try like this</P><P></P><P>In expression</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=if(Region&lt;&gt;'Atlanta',Region)</SPAN></P></BODY></HTML> Tue, 24 Sep 2013 14:06:40 GMT https://community.qlik.com/t5/QlikView/Eliminating-field-value/m-p/559756#M1140593 MayilVahanan 2013-09-24T14:06:40Z Re: Eliminating field value https://community.qlik.com/t5/QlikView/Eliminating-field-value/m-p/559757#M1140594 <HTML><HEAD></HEAD><BODY><P>Try expression for the list box, expression:</P><P></P><P>=If(Region&lt;&gt;'Atlanta', Region)</P></BODY></HTML> Tue, 24 Sep 2013 14:26:42 GMT https://community.qlik.com/t5/QlikView/Eliminating-field-value/m-p/559757#M1140594 tresB 2013-09-24T14:26:42Z Re: Eliminating field value https://community.qlik.com/t5/QlikView/Eliminating-field-value/m-p/559758#M1140595 <HTML><HEAD></HEAD><BODY><P>=if(Region&lt;&gt;'Atlanta',Region)</P></BODY></HTML> Tue, 24 Sep 2013 14:35:32 GMT https://community.qlik.com/t5/QlikView/Eliminating-field-value/m-p/559758#M1140595 nizamsha 2013-09-24T14:35:32Z Re: Eliminating field value https://community.qlik.com/t5/QlikView/Eliminating-field-value/m-p/559759#M1140596 <HTML><HEAD></HEAD><BODY><P>Or you can put that limitation on you expression with SetAnalysis.</P><P></P><P>Sum({$&lt;Region={'Atlanta'}&gt;}[Region Sales])</P></BODY></HTML> Tue, 24 Sep 2013 20:29:05 GMT https://community.qlik.com/t5/QlikView/Eliminating-field-value/m-p/559759#M1140596 2013-09-24T20:29:05Z