topic Re: If with Null comparison in QlikView https://community.qlik.com/t5/QlikView/If-with-Null-comparison/m-p/737207#M263643 <HTML><HEAD></HEAD><BODY><P>len(trim(Status))&gt;0&nbsp;&nbsp;&nbsp;&nbsp; not null</P></BODY></HTML> Wed, 01 Oct 2014 14:06:46 GMT maxgro 2014-10-01T14:06:46Z If with Null comparison https://community.qlik.com/t5/QlikView/If-with-Null-comparison/m-p/737206#M263642 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have expression as below. I have to compare if the status is null. How can I make.</P><P></P><P>=if(Id&lt;&gt;1,date(StatusDate), if(Status='Status1', 'ST1',if(<SPAN style="color: #ff6600;">Status is null</SPAN>, 'BLANK',date(StatusDate))))</P><P></P><P>It is giving expression error. If my status field no value I want to show'BLANK'.</P><P></P><P>Thanks..</P></BODY></HTML> Wed, 01 Oct 2014 14:05:24 GMT https://community.qlik.com/t5/QlikView/If-with-Null-comparison/m-p/737206#M263642 2014-10-01T14:05:24Z Re: If with Null comparison https://community.qlik.com/t5/QlikView/If-with-Null-comparison/m-p/737207#M263643 <HTML><HEAD></HEAD><BODY><P>len(trim(Status))&gt;0&nbsp;&nbsp;&nbsp;&nbsp; not null</P></BODY></HTML> Wed, 01 Oct 2014 14:06:46 GMT https://community.qlik.com/t5/QlikView/If-with-Null-comparison/m-p/737207#M263643 maxgro 2014-10-01T14:06:46Z Re: If with Null comparison https://community.qlik.com/t5/QlikView/If-with-Null-comparison/m-p/737208#M263644 <HTML><HEAD></HEAD><BODY><P>You can use "IsNull(Status)"</P><P></P><P>Regards,<BR />Gabriel</P></BODY></HTML> Wed, 01 Oct 2014 14:09:49 GMT https://community.qlik.com/t5/QlikView/If-with-Null-comparison/m-p/737208#M263644 Anonymous 2014-10-01T14:09:49Z