topic Re: Spaces in QlikView https://community.qlik.com/t5/QlikView/Spaces/m-p/1189891#M384611 <HTML><HEAD></HEAD><BODY><P>Have you tried this as your where statement?</P><P></P><P><STRONG>Where Len(Trim(T$CPRJ)) &gt; 0;</STRONG></P></BODY></HTML> Wed, 21 Sep 2016 19:49:53 GMT sunny_talwar 2016-09-21T19:49:53Z Spaces https://community.qlik.com/t5/QlikView/Spaces/m-p/1189890#M384610 <HTML><HEAD></HEAD><BODY><P>I know this is a common problem but I've checked all the previous posts and still can't solve this issue. For some reason I am still getting an output that either is null or has spaces... Code and output below:</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/138211_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P><IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/138221_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></P><P>Help!!</P></BODY></HTML> Wed, 21 Sep 2016 19:08:12 GMT https://community.qlik.com/t5/QlikView/Spaces/m-p/1189890#M384610 2016-09-21T19:08:12Z Re: Spaces https://community.qlik.com/t5/QlikView/Spaces/m-p/1189891#M384611 <HTML><HEAD></HEAD><BODY><P>Have you tried this as your where statement?</P><P></P><P><STRONG>Where Len(Trim(T$CPRJ)) &gt; 0;</STRONG></P></BODY></HTML> Wed, 21 Sep 2016 19:49:53 GMT https://community.qlik.com/t5/QlikView/Spaces/m-p/1189891#M384611 sunny_talwar 2016-09-21T19:49:53Z Re: Spaces https://community.qlik.com/t5/QlikView/Spaces/m-p/1189892#M384612 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Test these changes in the script<IMG alt="trim.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/138230_trim.png" style="height: 409px; width: 620px;" /></P></BODY></HTML> Wed, 21 Sep 2016 21:03:33 GMT https://community.qlik.com/t5/QlikView/Spaces/m-p/1189892#M384612 el_aprendiz111 2016-09-21T21:03:33Z Re: Spaces https://community.qlik.com/t5/QlikView/Spaces/m-p/1189893#M384613 <HTML><HEAD></HEAD><BODY><P>Are you certain that it is spaces and not some other non-printable character? Trust me this does happen on occasion! </P></BODY></HTML> Thu, 22 Sep 2016 08:09:42 GMT https://community.qlik.com/t5/QlikView/Spaces/m-p/1189893#M384613 adamdavi3s 2016-09-22T08:09:42Z