topic Not null in QlikView https://community.qlik.com/t5/QlikView/Not-null/m-p/709500#M1068487 <HTML><HEAD></HEAD><BODY><P>what is the syntax for checking not null condition</P><P>thanks in advance</P></BODY></HTML> Thu, 04 Sep 2014 12:30:40 GMT 2014-09-04T12:30:40Z Not null https://community.qlik.com/t5/QlikView/Not-null/m-p/709500#M1068487 <HTML><HEAD></HEAD><BODY><P>what is the syntax for checking not null condition</P><P>thanks in advance</P></BODY></HTML> Thu, 04 Sep 2014 12:30:40 GMT https://community.qlik.com/t5/QlikView/Not-null/m-p/709500#M1068487 2014-09-04T12:30:40Z Re: Not null https://community.qlik.com/t5/QlikView/Not-null/m-p/709501#M1068488 <HTML><HEAD></HEAD><BODY><P>If( <STRONG>Not IsNull</STRONG>(YourField/Expression), 'Not Null', 'Null')</P></BODY></HTML> Thu, 04 Sep 2014 12:34:51 GMT https://community.qlik.com/t5/QlikView/Not-null/m-p/709501#M1068488 tresB 2014-09-04T12:34:51Z Re: Not null https://community.qlik.com/t5/QlikView/Not-null/m-p/709502#M1068489 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>and sometimes (especially with flat files), it might be required to add ... and trim(Field)&lt;&gt;''</P><P></P><P>Regards</P></BODY></HTML> Thu, 04 Sep 2014 12:37:19 GMT https://community.qlik.com/t5/QlikView/Not-null/m-p/709502#M1068489 Anonymous 2014-09-04T12:37:19Z Re: Not null https://community.qlik.com/t5/QlikView/Not-null/m-p/709503#M1068490 <HTML><HEAD></HEAD><BODY><P>not isnull(field)</P><P></P><P>or</P><P></P><P>len(trim(field)) &gt; 0</P></BODY></HTML> Thu, 04 Sep 2014 12:40:35 GMT https://community.qlik.com/t5/QlikView/Not-null/m-p/709503#M1068490 maxgro 2014-09-04T12:40:35Z Re: Not null https://community.qlik.com/t5/QlikView/Not-null/m-p/709504#M1068491 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-style: inherit; font-family: inherit; font-weight: inherit;"> </SPAN><STRONG style=": ; color: #3d3d3d; font-style: inherit; font-family: inherit; font-weight: inherit;"><SPAN><SPAN>No IsNull</SPAN></SPAN>(Campo)</STRONG><SPAN style="color: #3d3d3d; font-style: inherit; font-family: inherit; font-weight: inherit;"> </SPAN></P></BODY></HTML> Thu, 04 Sep 2014 12:43:00 GMT https://community.qlik.com/t5/QlikView/Not-null/m-p/709504#M1068491 walterlh 2014-09-04T12:43:00Z Re: Not null https://community.qlik.com/t5/QlikView/Not-null/m-p/709505#M1068492 <HTML><HEAD></HEAD><BODY><P>hi</P><P>isnull(field)=0</P></BODY></HTML> Thu, 04 Sep 2014 12:43:13 GMT https://community.qlik.com/t5/QlikView/Not-null/m-p/709505#M1068492 mohamed_ahid 2014-09-04T12:43:13Z