Isnull behaving weirdly in Qlik Sense 3.2

[vkish16161]

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.

rwunderlich‌ marcus_sommer‌

[marcus_sommer · Accepted solution]

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