topic Nulls in the expression in QlikView https://community.qlik.com/t5/QlikView/Nulls-in-the-expression/m-p/227305#M79416 <HTML><HEAD></HEAD><BODY><P>If you want to do it from expression you can do it with a conditional:</P><P>If (FIELD &lt;&gt; NULL)</P><P>Your expresion.</P><P>Or</P><P>If you are going to do a SUM in your expression:</P><P>SUM ( {1 - $&lt; FIELD = {NULL}&gt;} FIELD)</P><P>Maybe if you explain us a little more about your question we can help you more.</P><P>Regards</P><P>Orlando</P></BODY></HTML> Mon, 04 Oct 2010 20:01:42 GMT 2010-10-04T20:01:42Z Nulls in the expression https://community.qlik.com/t5/QlikView/Nulls-in-the-expression/m-p/227301#M79412 <HTML><HEAD></HEAD><BODY><P>hello friends...</P><P>how do I delete nulls in the expression?</P><P></P><P>I have date field, with null values (in expression).. Can I delete they??<BR /></P></BODY></HTML> Mon, 04 Oct 2010 18:28:11 GMT https://community.qlik.com/t5/QlikView/Nulls-in-the-expression/m-p/227301#M79412 2010-10-04T18:28:11Z Nulls in the expression https://community.qlik.com/t5/QlikView/Nulls-in-the-expression/m-p/227302#M79413 <HTML><HEAD></HEAD><BODY><P>Hi Rodrigoreis:</P><P>In the properties of the chart on the tab dimensions, you have to check the option "Supress when value is null", i think this may work to you. Tell us if it was your answer.</P><P>Regards</P><P>Orlando</P><P></P></BODY></HTML> Mon, 04 Oct 2010 19:29:37 GMT https://community.qlik.com/t5/QlikView/Nulls-in-the-expression/m-p/227302#M79413 2010-10-04T19:29:37Z Nulls in the expression https://community.qlik.com/t5/QlikView/Nulls-in-the-expression/m-p/227303#M79414 <HTML><HEAD></HEAD><BODY><P>I need delete nulls in the expression, in tab expression...</P></BODY></HTML> Mon, 04 Oct 2010 19:54:47 GMT https://community.qlik.com/t5/QlikView/Nulls-in-the-expression/m-p/227303#M79414 2010-10-04T19:54:47Z Nulls in the expression https://community.qlik.com/t5/QlikView/Nulls-in-the-expression/m-p/227304#M79415 <HTML><HEAD></HEAD><BODY><P>Typically you should not have a date as an expression - it would rather be a dimension (with the solution made by Orlando). In an expression you might wish to see results of an aggregation, like MAX(MyDate) - but this will ignore NULLs.</P><P>HTH<BR />Peter</P></BODY></HTML> Mon, 04 Oct 2010 19:59:37 GMT https://community.qlik.com/t5/QlikView/Nulls-in-the-expression/m-p/227304#M79415 prieper 2010-10-04T19:59:37Z Nulls in the expression https://community.qlik.com/t5/QlikView/Nulls-in-the-expression/m-p/227305#M79416 <HTML><HEAD></HEAD><BODY><P>If you want to do it from expression you can do it with a conditional:</P><P>If (FIELD &lt;&gt; NULL)</P><P>Your expresion.</P><P>Or</P><P>If you are going to do a SUM in your expression:</P><P>SUM ( {1 - $&lt; FIELD = {NULL}&gt;} FIELD)</P><P>Maybe if you explain us a little more about your question we can help you more.</P><P>Regards</P><P>Orlando</P></BODY></HTML> Mon, 04 Oct 2010 20:01:42 GMT https://community.qlik.com/t5/QlikView/Nulls-in-the-expression/m-p/227305#M79416 2010-10-04T20:01:42Z