topic Re: NULL vs SPACE in QlikView https://community.qlik.com/t5/QlikView/NULL-vs-SPACE/m-p/856638#M656467 <HTML><HEAD></HEAD><BODY><P>try:</P><P>if(Len(TRIM((SOURCE))=0....</P></BODY></HTML> Wed, 27 May 2015 07:29:25 GMT robert_mika 2015-05-27T07:29:25Z NULL vs SPACE https://community.qlik.com/t5/QlikView/NULL-vs-SPACE/m-p/856637#M656466 <HTML><HEAD></HEAD><BODY><P>Hello, I would like to create column in loading script base on the source column. My new column should be a flag: </P><P></P><P>if (isnull(SOURCE), 1, 0)</P><P></P><P>The problem is that in source data sometimes I have null but sometimes it is space or even several spaces. I tried with TRIM function:</P><P>if(isnull(trim(SOURCE)), 1, 0)</P><P>but it did not work.</P><P></P><P>Could you help me please?</P></BODY></HTML> Wed, 27 May 2015 07:07:18 GMT https://community.qlik.com/t5/QlikView/NULL-vs-SPACE/m-p/856637#M656466 arsenal1983 2015-05-27T07:07:18Z Re: NULL vs SPACE https://community.qlik.com/t5/QlikView/NULL-vs-SPACE/m-p/856638#M656467 <HTML><HEAD></HEAD><BODY><P>try:</P><P>if(Len(TRIM((SOURCE))=0....</P></BODY></HTML> Wed, 27 May 2015 07:29:25 GMT https://community.qlik.com/t5/QlikView/NULL-vs-SPACE/m-p/856638#M656467 robert_mika 2015-05-27T07:29:25Z