topic suppressing nulls in QlikView https://community.qlik.com/t5/QlikView/suppressing-nulls/m-p/194142#M55149 <HTML><HEAD></HEAD><BODY><P>In listbox in available fields there is &lt;Expression&gt; option. In there you can type expression that suspend empty records. Something like =if(FieldName &lt;&gt;'', FieldName). If after this empty records are still shown then you really may have some "not so empty" values as Ryan sad.</P></BODY></HTML> Wed, 08 Sep 2010 23:33:35 GMT 2010-09-08T23:33:35Z suppressing nulls https://community.qlik.com/t5/QlikView/suppressing-nulls/m-p/194140#M55147 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>is there a way to suppress nulls in a List Box?</P><P>Thanks!</P></BODY></HTML> Wed, 08 Sep 2010 22:12:43 GMT https://community.qlik.com/t5/QlikView/suppressing-nulls/m-p/194140#M55147 2010-09-08T22:12:43Z suppressing nulls https://community.qlik.com/t5/QlikView/suppressing-nulls/m-p/194141#M55148 <HTML><HEAD></HEAD><BODY><P>List boxes should supress nulls all on thier own. Are you sure they're nulls? Perhaps your database is being naughty and returning you &amp;nbsp characters or something otherwise equally insidious.</P></BODY></HTML> Wed, 08 Sep 2010 22:59:18 GMT https://community.qlik.com/t5/QlikView/suppressing-nulls/m-p/194141#M55148 2010-09-08T22:59:18Z suppressing nulls https://community.qlik.com/t5/QlikView/suppressing-nulls/m-p/194142#M55149 <HTML><HEAD></HEAD><BODY><P>In listbox in available fields there is &lt;Expression&gt; option. In there you can type expression that suspend empty records. Something like =if(FieldName &lt;&gt;'', FieldName). If after this empty records are still shown then you really may have some "not so empty" values as Ryan sad.</P></BODY></HTML> Wed, 08 Sep 2010 23:33:35 GMT https://community.qlik.com/t5/QlikView/suppressing-nulls/m-p/194142#M55149 2010-09-08T23:33:35Z