Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Spaces

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:

Help!!

3 Replies
sunny_talwar

Have you tried this as your where statement?

Where Len(Trim(T$CPRJ)) > 0;

el_aprendiz111
Specialist
Specialist

Hi,

Test these changes in the scripttrim.png

adamdavi3s
Master
Master

Are you certain that it is spaces and not some other non-printable character? Trust me this does happen on occasion!