1 Reply Latest reply: Oct 11, 2017 11:00 AM by Marcus Sommer RSS

    Isnull behaving weirdly in Qlik Sense 3.2

    Vishnu Chakravaram

      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