https://community.qlik.com/t5/App-Development/Remove-Nulls-and-or-blank-values/m-p/1518807#M37074 <P>I have a table where I want to remove Null and/or blank values in the script. I've used not IsNull(), field &lt;&gt; '' and len(trim(field))&gt;0 and nothing works. I even checked the data in the table (see&nbsp;screenshot)&nbsp;and it appears to be null. I unchecked show null values in the table and they disappear. Does anyone know why the records would still appear?</P><P>&nbsp;</P><P>Thank you,</P><P>Ed<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Null.JPG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/1916i58B3FF1F36603948/image-size/large?v=v2&amp;px=999" role="button" title="Null.JPG" alt="Null.JPG" /></span></P> Mon, 10 Dec 2018 16:11:13 GMT egoss_cynosure_ 2018-12-10T16:11:13Z https://community.qlik.com/t5/App-Development/Remove-Nulls-and-or-blank-values/m-p/1518807#M37074 <P>I have a table where I want to remove Null and/or blank values in the script. I've used not IsNull(), field &lt;&gt; '' and len(trim(field))&gt;0 and nothing works. I even checked the data in the table (see&nbsp;screenshot)&nbsp;and it appears to be null. I unchecked show null values in the table and they disappear. Does anyone know why the records would still appear?</P><P>&nbsp;</P><P>Thank you,</P><P>Ed<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Null.JPG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/1916i58B3FF1F36603948/image-size/large?v=v2&amp;px=999" role="button" title="Null.JPG" alt="Null.JPG" /></span></P> Mon, 10 Dec 2018 16:11:13 GMT https://community.qlik.com/t5/App-Development/Remove-Nulls-and-or-blank-values/m-p/1518807#M37074 egoss_cynosure_ 2018-12-10T16:11:13Z https://community.qlik.com/t5/App-Development/Remove-Nulls-and-or-blank-values/m-p/1519208#M37105 <P>Hi, do you have a sample QVF you could share?</P> Tue, 11 Dec 2018 11:39:11 GMT https://community.qlik.com/t5/App-Development/Remove-Nulls-and-or-blank-values/m-p/1519208#M37105 hopkinsc 2018-12-11T11:39:11Z