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: 
vkish16161
Creator III
Creator III

Isnull behaving weirdly in Qlik Sense 3.2

All,

I'm trying to ascertain if there's any tangible difference in using "where not isnull(Product)" vs "Where len(Product) > 0 "

For. e.g.

1. load * where len(Concat_Flag_Unpivot) > 0 ;

2. load * where not isnull(Concat_Flag_Unpivot) ;

My understanding is that both 1 and 2 will yield same results but they're not.

Help appreciated.

rwunderlichmarcus_sommer

1 Solution

Accepted Solutions
marcus_sommer

Isnull() is only true by real NULL whereby an empty fieldvalue like '' or any kind of spaces like ' ' are not NULL in the sense of isnull(). This is very well explained here: NULL handling in QlikView.

- Marcus

View solution in original post

1 Reply
marcus_sommer

Isnull() is only true by real NULL whereby an empty fieldvalue like '' or any kind of spaces like ' ' are not NULL in the sense of isnull(). This is very well explained here: NULL handling in QlikView.

- Marcus