topic Null fields and or empty string and or ... in QlikView https://community.qlik.com/t5/QlikView/Null-fields-and-or-empty-string-and-or/m-p/257963#M707165 <HTML><HEAD></HEAD><BODY><P>WHERE LEN(TRIM([Field Name])) should do the selection.</P><P>Think that you need to specify the use of the NOT:</P><P>WHERE NOT(ISNULL([Field Name])) AND ....</P><P>should then work.</P><P></P><P>HTH<BR />Peter</P></BODY></HTML> Sat, 07 Jan 2012 21:39:05 GMT prieper 2012-01-07T21:39:05Z Null fields and or empty string and or ... https://community.qlik.com/t5/QlikView/Null-fields-and-or-empty-string-and-or/m-p/257962#M707164 <HTML><HEAD></HEAD><BODY><P>Q1:</P><P>When I pull data and I have a field and the field appears to be either Null, an empty string, or it has a few spaces in it, and when I use the script, </P><P><SPAN style="color: #0000ff; font-size: 10pt;"> </SPAN> </P><P><SPAN style="color: #0000ff; font-size: 10pt;">Where not</SPAN><SPAN style="font-size: 10pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 10pt;">IsNull</SPAN><SPAN style="font-size: 10pt;">(</SPAN><SPAN style="color: #800000; font-size: 10pt;">[Field Name]</SPAN><SPAN style="font-size: 10pt;">) and Len(trim(</SPAN><SPAN style="color: #800000; font-size: 10pt;">[Field Name])</SPAN><SPAN style="font-size: 10pt;">) &gt;0 and it still does not delete those empty lines, what should I do to get rid of them?</SPAN></P><P>Q2:&nbsp; Then just by chance I did this with a resident load, trim([Field Name]) as [Field Name] and it deleted all the lines where Field Name was empty.&nbsp; I did not have any code after that. How did this get rid of empty rows when I only told it to trim them, not delte them?&nbsp; Maybe I am not understanding the use of trim or?&nbsp; Any who, please answer both Q's so I can figure this out.&nbsp; Many Thanks, Sean</P></BODY></HTML> Sat, 07 Jan 2012 01:43:53 GMT https://community.qlik.com/t5/QlikView/Null-fields-and-or-empty-string-and-or/m-p/257962#M707164 2012-01-07T01:43:53Z Null fields and or empty string and or ... https://community.qlik.com/t5/QlikView/Null-fields-and-or-empty-string-and-or/m-p/257963#M707165 <HTML><HEAD></HEAD><BODY><P>WHERE LEN(TRIM([Field Name])) should do the selection.</P><P>Think that you need to specify the use of the NOT:</P><P>WHERE NOT(ISNULL([Field Name])) AND ....</P><P>should then work.</P><P></P><P>HTH<BR />Peter</P></BODY></HTML> Sat, 07 Jan 2012 21:39:05 GMT https://community.qlik.com/t5/QlikView/Null-fields-and-or-empty-string-and-or/m-p/257963#M707165 prieper 2012-01-07T21:39:05Z