Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
m_perreault
Creator III
Creator III

Empty Strings to Nulls

Hi All,

I am loading in a file to Qlik Sense that contains many empty strings as shown below.

emptystring.png

I know in the script I can do

If(Len(Trim(Id)) <1, Null(),Id) as Id

But this table has 80+ fields and I believe this will be the case for other tables I am bringing in.

Is there a way for me to tell Qlik to universally treat strings with Len(Trim(Field)) = 0  as nulls?

Thanks,
Mark

1 Solution

Accepted Solutions
m_perreault
Creator III
Creator III
Author

Found the answer reading here.

Set NullInterpret = '';

View solution in original post

1 Reply
m_perreault
Creator III
Creator III
Author

Found the answer reading here.

Set NullInterpret = '';