topic Re: How to restrict the null values from the facts at the script level, in QlikView https://community.qlik.com/t5/QlikView/How-to-restrict-the-null-values-from-the-facts-at-the-script/m-p/747192#M266629 <HTML><HEAD></HEAD><BODY><P>you can use same exp in calculation dimension</P></BODY></HTML> Sat, 01 Nov 2014 10:49:38 GMT sakamsureshbabu 2014-11-01T10:49:38Z How to restrict the null values from the facts at the script level, https://community.qlik.com/t5/QlikView/How-to-restrict-the-null-values-from-the-facts-at-the-script/m-p/747188#M266625 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>Can anybody tell how to restrict the null value at the script level, </P><P>i am using Len(Fact)&lt;&gt;0 and and Not IsNull(Amount).</P><P></P><P>but it is not working, </P><P></P><P>Please help into this,</P><P></P><P>Thanks in advance</P></BODY></HTML> Sat, 01 Nov 2014 06:27:39 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-the-null-values-from-the-facts-at-the-script/m-p/747188#M266625 2014-11-01T06:27:39Z Re: How to restrict the null values from the facts at the script level, https://community.qlik.com/t5/QlikView/How-to-restrict-the-null-values-from-the-facts-at-the-script/m-p/747189#M266626 <HTML><HEAD></HEAD><BODY><P>What kind of not working ?</P><P></P><P>Could you paste in your actual script ?</P></BODY></HTML> Sat, 01 Nov 2014 06:38:47 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-the-null-values-from-the-facts-at-the-script/m-p/747189#M266626 Anonymous 2014-11-01T06:38:47Z Re: How to restrict the null values from the facts at the script level, https://community.qlik.com/t5/QlikView/How-to-restrict-the-null-values-from-the-facts-at-the-script/m-p/747190#M266627 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You are using the correct functions also read this document</P><P></P><P><A href="https://community.qlik.com/docs/DOC-3155">NULL handling in QlikView</A></P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Sat, 01 Nov 2014 06:41:49 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-the-null-values-from-the-facts-at-the-script/m-p/747190#M266627 its_anandrjs 2014-11-01T06:41:49Z Re: How to restrict the null values from the facts at the script level, https://community.qlik.com/t5/QlikView/How-to-restrict-the-null-values-from-the-facts-at-the-script/m-p/747191#M266628 <HTML><HEAD></HEAD><BODY><P>I used <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Len(Fact)&lt;&gt;0, but it is only (Fact)&lt;&gt;0, Len function should not used</SPAN></P></BODY></HTML> Sat, 01 Nov 2014 10:07:16 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-the-null-values-from-the-facts-at-the-script/m-p/747191#M266628 2014-11-01T10:07:16Z Re: How to restrict the null values from the facts at the script level, https://community.qlik.com/t5/QlikView/How-to-restrict-the-null-values-from-the-facts-at-the-script/m-p/747192#M266629 <HTML><HEAD></HEAD><BODY><P>you can use same exp in calculation dimension</P></BODY></HTML> Sat, 01 Nov 2014 10:49:38 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-the-null-values-from-the-facts-at-the-script/m-p/747192#M266629 sakamsureshbabu 2014-11-01T10:49:38Z