Qlik Community

Qlik Sense App Development

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

luisguerra
New Contributor

Condition where if field is Null- error

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

1 Reply
MVP
MVP

Re: Condition where if field is Null- error

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?