topic Re: Not Null Expression in QlikView https://community.qlik.com/t5/QlikView/Not-Null-Expression/m-p/1213677#M388967 <HTML><HEAD></HEAD><BODY><P><EM>if(not IsNull([Stock])</EM></P><P><EM><BR /></EM></P><P><EM>???<BR /></EM></P></BODY></HTML> Tue, 08 Nov 2016 17:05:36 GMT Anonymous 2016-11-08T17:05:36Z Not Null Expression https://community.qlik.com/t5/QlikView/Not-Null-Expression/m-p/1213675#M388965 <HTML><HEAD></HEAD><BODY><P>Dear Qlikview Gurus</P><P></P><P>Please assist me to convert <STRONG style="text-decoration: underline;">NULL EXPRESSION</STRONG> <EM>if(IsNull([Stock])</EM> to <SPAN style="text-decoration: underline;"><STRONG>NOT NULL EXPRESSION</STRONG></SPAN></P><P></P><P>Regards</P><P>Mahlatse</P></BODY></HTML> Tue, 08 Nov 2016 15:43:04 GMT https://community.qlik.com/t5/QlikView/Not-Null-Expression/m-p/1213675#M388965 2016-11-08T15:43:04Z Re: Not Null Expression https://community.qlik.com/t5/QlikView/Not-Null-Expression/m-p/1213676#M388966 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>If(not IsNull(Stock).....</STRONG></P></BODY></HTML> Tue, 08 Nov 2016 17:04:54 GMT https://community.qlik.com/t5/QlikView/Not-Null-Expression/m-p/1213676#M388966 sunny_talwar 2016-11-08T17:04:54Z Re: Not Null Expression https://community.qlik.com/t5/QlikView/Not-Null-Expression/m-p/1213677#M388967 <HTML><HEAD></HEAD><BODY><P><EM>if(not IsNull([Stock])</EM></P><P><EM><BR /></EM></P><P><EM>???<BR /></EM></P></BODY></HTML> Tue, 08 Nov 2016 17:05:36 GMT https://community.qlik.com/t5/QlikView/Not-Null-Expression/m-p/1213677#M388967 Anonymous 2016-11-08T17:05:36Z Re: Not Null Expression https://community.qlik.com/t5/QlikView/Not-Null-Expression/m-p/1213678#M388968 <HTML><HEAD></HEAD><BODY><P><STRONG style="color: #3d3d3d; font-family: Helvetica;">IF(Len(Trim(<EM>Stock</EM>))=0, 'Null', 'Not Null')</STRONG></P><P><STRONG style="color: #3d3d3d; font-family: Helvetica;"><BR /></STRONG></P><P><STRONG style="color: #3d3d3d; font-family: Helvetica;"><STRONG style="color: #3d3d3d; font-family: Helvetica;">IF(Len(Trim(<EM>Stock</EM>))&gt;0, 'Not Null', 'Null')</STRONG></STRONG></P></BODY></HTML> Wed, 10 May 2017 20:50:33 GMT https://community.qlik.com/t5/QlikView/Not-Null-Expression/m-p/1213678#M388968 wdchristensen 2017-05-10T20:50:33Z