topic Re: Suppress Blank Values in List Box in QlikView https://community.qlik.com/t5/QlikView/Suppress-Blank-Values-in-List-Box/m-p/983700#M526003 <HTML><HEAD></HEAD><BODY><P>Yes, in list box take expression instead of direct field.</P><P></P><P>Expression:</P><P></P><P>if(field&lt;&gt; ' ',field)</P></BODY></HTML> Wed, 09 Dec 2015 18:12:54 GMT vardhancse 2015-12-09T18:12:54Z Suppress Blank Values in List Box https://community.qlik.com/t5/QlikView/Suppress-Blank-Values-in-List-Box/m-p/983697#M526000 <HTML><HEAD></HEAD><BODY><P>How can I suppress blank values in a list box?</P></BODY></HTML> Wed, 09 Dec 2015 17:40:32 GMT https://community.qlik.com/t5/QlikView/Suppress-Blank-Values-in-List-Box/m-p/983697#M526000 cbaqir 2015-12-09T17:40:32Z Re: Suppress Blank Values in List Box https://community.qlik.com/t5/QlikView/Suppress-Blank-Values-in-List-Box/m-p/983698#M526001 <HTML><HEAD></HEAD><BODY><P>use expression in list box and use this expression</P><P></P><P>if (field &lt;&gt; '',field)</P><P></P><P>hope it helps</P><P>Raj</P></BODY></HTML> Wed, 09 Dec 2015 17:57:29 GMT https://community.qlik.com/t5/QlikView/Suppress-Blank-Values-in-List-Box/m-p/983698#M526001 Anonymous 2015-12-09T17:57:29Z Re: Suppress Blank Values in List Box https://community.qlik.com/t5/QlikView/Suppress-Blank-Values-in-List-Box/m-p/983699#M526002 <HTML><HEAD></HEAD><BODY><P>If(Len(Trim(Field)),Field)</P></BODY></HTML> Wed, 09 Dec 2015 18:08:30 GMT https://community.qlik.com/t5/QlikView/Suppress-Blank-Values-in-List-Box/m-p/983699#M526002 MarcoWedel 2015-12-09T18:08:30Z Re: Suppress Blank Values in List Box https://community.qlik.com/t5/QlikView/Suppress-Blank-Values-in-List-Box/m-p/983700#M526003 <HTML><HEAD></HEAD><BODY><P>Yes, in list box take expression instead of direct field.</P><P></P><P>Expression:</P><P></P><P>if(field&lt;&gt; ' ',field)</P></BODY></HTML> Wed, 09 Dec 2015 18:12:54 GMT https://community.qlik.com/t5/QlikView/Suppress-Blank-Values-in-List-Box/m-p/983700#M526003 vardhancse 2015-12-09T18:12:54Z