topic null field in QlikView https://community.qlik.com/t5/QlikView/null-field/m-p/501753#M692480 <HTML><HEAD></HEAD><BODY><P><SPAN id="result_box" lang="en"><SPAN class="hps">I tried several</SPAN> <SPAN class="hps">options</SPAN> <SPAN class="hps">but I could not</SPAN> <SPAN class="hps">bring</SPAN> <SPAN class="hps">field</SPAN> <SPAN class="hps">only when it</SPAN> <SPAN class="hps">is not null</SPAN>.<BR /><BR /><SPAN class="hps">Can you help me</SPAN> <SPAN class="hps">with the</SPAN> <SPAN class="hps">command to be</SPAN> <SPAN class="hps">used</SPAN><SPAN>?</SPAN></SPAN></P></BODY></HTML> Fri, 16 Aug 2013 20:55:31 GMT 2013-08-16T20:55:31Z null field https://community.qlik.com/t5/QlikView/null-field/m-p/501753#M692480 <HTML><HEAD></HEAD><BODY><P><SPAN id="result_box" lang="en"><SPAN class="hps">I tried several</SPAN> <SPAN class="hps">options</SPAN> <SPAN class="hps">but I could not</SPAN> <SPAN class="hps">bring</SPAN> <SPAN class="hps">field</SPAN> <SPAN class="hps">only when it</SPAN> <SPAN class="hps">is not null</SPAN>.<BR /><BR /><SPAN class="hps">Can you help me</SPAN> <SPAN class="hps">with the</SPAN> <SPAN class="hps">command to be</SPAN> <SPAN class="hps">used</SPAN><SPAN>?</SPAN></SPAN></P></BODY></HTML> Fri, 16 Aug 2013 20:55:31 GMT https://community.qlik.com/t5/QlikView/null-field/m-p/501753#M692480 2013-08-16T20:55:31Z Re: null field https://community.qlik.com/t5/QlikView/null-field/m-p/501754#M692481 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>In script you can use</P><P></P><P>where len(fieldName)&gt;0;</P><P></P><P>or</P><P>where not isnull(fieldName);</P><P></P><P>In chart expression using set analysis</P><P>Sum({&lt;FieldName={*}&gt;} FieldName1)</P><P></P><P>Hope it helps</P><P></P><P>Celambarasan</P></BODY></HTML> Fri, 16 Aug 2013 21:00:20 GMT https://community.qlik.com/t5/QlikView/null-field/m-p/501754#M692481 CELAMBARASAN 2013-08-16T21:00:20Z Re: null field https://community.qlik.com/t5/QlikView/null-field/m-p/501755#M692482 <HTML><HEAD></HEAD><BODY><P><SPAN id="result_box" lang="en"><SPAN class="hps">continues</SPAN>, <SPAN class="hps">the second</SPAN> <SPAN class="hps">option that</SPAN> <SPAN class="hps">was</SPAN> <SPAN class="hps">sent</SPAN> <SPAN class="hps">my test</SPAN>, <SPAN class="hps">the</SPAN> <SPAN class="hps">scrip</SPAN> <SPAN class="hps">is</SPAN> <SPAN class="hps">that I'm</SPAN> <SPAN class="hps">the problem</SPAN></SPAN></P></BODY></HTML> Fri, 16 Aug 2013 21:12:51 GMT https://community.qlik.com/t5/QlikView/null-field/m-p/501755#M692482 2013-08-16T21:12:51Z