topic Re: Delete null values in the LOAD in QlikView https://community.qlik.com/t5/QlikView/Delete-null-values-in-the-LOAD/m-p/686949#M1051554 <HTML><HEAD></HEAD><BODY><P>Where not (isnull(field1) or isnull(field2) or ...)</P></BODY></HTML> Thu, 23 Oct 2014 18:06:15 GMT MarcoWedel 2014-10-23T18:06:15Z Delete null values in the LOAD https://community.qlik.com/t5/QlikView/Delete-null-values-in-the-LOAD/m-p/686948#M1051553 <HTML><HEAD></HEAD><BODY><P>Hi everybody.</P><P>I have null values and i dont wanna see them.</P><P>Can i delete this values in the load statements?</P><P>for example</P><P></P><P>LOAD //id, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; num_web AS CodigoWeb, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; coditm AS Articulo, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; precio, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; //cant, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; asignado AS CantidadAdjudicada</P><P></P><P></P><P>WHERE nobody of this columns have null values?</P><P></P><P>THANK you all!</P></BODY></HTML> Thu, 23 Oct 2014 17:55:45 GMT https://community.qlik.com/t5/QlikView/Delete-null-values-in-the-LOAD/m-p/686948#M1051553 2014-10-23T17:55:45Z Re: Delete null values in the LOAD https://community.qlik.com/t5/QlikView/Delete-null-values-in-the-LOAD/m-p/686949#M1051554 <HTML><HEAD></HEAD><BODY><P>Where not (isnull(field1) or isnull(field2) or ...)</P></BODY></HTML> Thu, 23 Oct 2014 18:06:15 GMT https://community.qlik.com/t5/QlikView/Delete-null-values-in-the-LOAD/m-p/686949#M1051554 MarcoWedel 2014-10-23T18:06:15Z Re: Delete null values in the LOAD https://community.qlik.com/t5/QlikView/Delete-null-values-in-the-LOAD/m-p/686950#M1051555 <HTML><HEAD></HEAD><BODY><P>Intenta esto:</P><P></P><P><IMG alt="Capture.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/69568_Capture.PNG.png" /></P></BODY></HTML> Thu, 23 Oct 2014 18:07:11 GMT https://community.qlik.com/t5/QlikView/Delete-null-values-in-the-LOAD/m-p/686950#M1051555 albertovarela 2014-10-23T18:07:11Z Re: Delete null values in the LOAD https://community.qlik.com/t5/QlikView/Delete-null-values-in-the-LOAD/m-p/686951#M1051556 <HTML><HEAD></HEAD><BODY><P>Please close thread if your question is answered.</P><P>Thanks</P><P>Regards</P><P>Marco</P></BODY></HTML> Fri, 24 Oct 2014 06:10:08 GMT https://community.qlik.com/t5/QlikView/Delete-null-values-in-the-LOAD/m-p/686951#M1051556 MarcoWedel 2014-10-24T06:10:08Z Re: Delete null values in the LOAD https://community.qlik.com/t5/QlikView/Delete-null-values-in-the-LOAD/m-p/686952#M1051557 <HTML><HEAD></HEAD><BODY><P>Dont know why i can´t put correct answer!</P></BODY></HTML> Fri, 24 Oct 2014 13:14:04 GMT https://community.qlik.com/t5/QlikView/Delete-null-values-in-the-LOAD/m-p/686952#M1051557 2014-10-24T13:14:04Z Re: Delete null values in the LOAD https://community.qlik.com/t5/QlikView/Delete-null-values-in-the-LOAD/m-p/686953#M1051558 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>it's OK, just saw your thread isn't opened as a question.</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Fri, 24 Oct 2014 14:04:02 GMT https://community.qlik.com/t5/QlikView/Delete-null-values-in-the-LOAD/m-p/686953#M1051558 MarcoWedel 2014-10-24T14:04:02Z Re: Delete null values in the LOAD https://community.qlik.com/t5/QlikView/Delete-null-values-in-the-LOAD/m-p/686954#M1051559 <HTML><HEAD></HEAD><BODY><P>Ok. Sory for that. I´ll pay more atention the next time.</P><P>Cheers!</P></BODY></HTML> Fri, 24 Oct 2014 14:19:14 GMT https://community.qlik.com/t5/QlikView/Delete-null-values-in-the-LOAD/m-p/686954#M1051559 2014-10-24T14:19:14Z