Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
rmgerasimov
Contributor
Contributor

Is blank value represent with '' or "" ?

Hi all, 

I want to check for black values. My question is how blank value is represent. With '' or with ""?

column_name != '';

or

column_name != "";


Labels (3)
1 Solution

Accepted Solutions
Or
MVP
MVP

Len(Column_Name) = 0 will catch both blanks and nulls.

Column_Name = '' will catch just blanks.

View solution in original post

1 Reply
Or
MVP
MVP

Len(Column_Name) = 0 will catch both blanks and nulls.

Column_Name = '' will catch just blanks.