Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

vkish16161
Contributor 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

Re: Isnull behaving weirdly in Qlik Sense 3.2

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

1 Reply

Re: Isnull behaving weirdly in Qlik Sense 3.2

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

Community Browser