Condition where if field is Null- error

luisguerra — Tue, 24 Oct 2017 19:38:25 GMT

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

Re: Condition where if field is Null- error

swuehl — Tue, 24 Oct 2017 20:08:22 GMT

everything from SQL SELECT to the next semicolon will be interpreted and executed by your SQL driver.

So why don't you just use the first SQL statement that works for your?