Isnull behaving weirdly in Qlik Sense 3.2

vkish16161 — Wed, 11 Oct 2017 14:54:42 GMT

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‌

Re: Isnull behaving weirdly in Qlik Sense 3.2

marcus_sommer — Wed, 11 Oct 2017 15:00:23 GMT

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

topic Isnull behaving weirdly in Qlik Sense 3.2 in App Development

Isnull behaving weirdly in Qlik Sense 3.2

Re: Isnull behaving weirdly in Qlik Sense 3.2