1 Reply Latest reply: Oct 24, 2017 4:08 PM by Stefan Wühl RSS

    Condition where if field is Null- error

    Luis Guerra

      Hi Guys! I have a problem.

      i have a condition "where" in my SQL: only will print data if my "DATE_FIELD" is null.

      In SQL works perfectly, but in Qlik sense not works.

      Can you helpme?



      My Code:

      In My SQL have the next sintaxis:----------------

      SELECT *

      FROM "table"

      WHERE "date_field" IS NULL



      But if i write inQlik sense: --------------------------

      LOAD *;

      SQL SELECT *

      FROM "NOMINA_IMI".dbo."empleados_sueldos"

      where  "date_field"=null;       <-- not work! retun 0