3 Replies Latest reply: Oct 17, 2017 3:27 AM by Grzegorz Smajdor RSS

    isnull() not working in QlikSense

    Grzegorz Smajdor

      Hi,

      I am trying to figure out the following problem.

      Please take a look at the example below.

       

      Achieved Start Date [AST]- is a field,from CSV file.

      In my example the field is just empty. There is no spaces, no hidden characters etc.

       

      Function isnull() return - 0 (FALSE). Not null? Thus it has something inside.

      Interesting? Stay with me

       

      My first thought - maybe Qlik recognizes this field as an empty string.

      I try istext() function - the result is TRUE

      Also, I tried len() function - the result is 0, so it means there is nothing - zero letters inside.


      What is more interesting...

      I try the isnum() function - it returns... FALSE.


      ANY IDEAS WHAT IS GOING ON?

      isnull.PNG

       

      Edited information about isnum/istext results.