Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Script, sql query: Where .... <> null

Hi,

I need some help. I´m trying to load data from an ODBC, but I don´t want to load null values. I´m trying to use a where clause in the script, but I don´t know how to write the sql-qeury.

Thanks in advance

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Script, sql query: Where .... <> null

Hi,

You can try IS NOT NULL clause in WHERE like below

Example:

SELECT

*

FROM Employee

WHERE FullName IS NOT NULL;

OR

SELECT

*

FROM Employee

WHERE Len(FullName) > 0;

Regards,

Jagan.

7 Replies
Luminary
Luminary

Re: Script, sql query: Where .... <> null

To filter null values in the database layer when reading from ODBC, it depends on the database vendor you use.

Not applicable

Re: Script, sql query: Where .... <> null

‌We use pervasive.

rupamjyotidas
Valued Contributor

Re: Script, sql query: Where .... <> null

Might Help:

Where Len(PrimaryKey)>0 or Not ISNULL(PrimaryKey)

viveknair1234
New Contributor III

Re: Script, sql query: Where .... <> null

SQL;

SELECT * FROM TABLE_NAME WHERE COLUMN_NAME IS NOT NULL

Replace TABLE_NAME with your table name and COLUMN_NAME with your column name

MVP & Luminary
MVP & Luminary

Re: Script, sql query: Where .... <> null

Hi,

You can try IS NOT NULL clause in WHERE like below

Example:

SELECT

*

FROM Employee

WHERE FullName IS NOT NULL;

OR

SELECT

*

FROM Employee

WHERE Len(FullName) > 0;

Regards,

Jagan.

lakshmikandh
Valued Contributor II

Re: Script, sql query: Where .... <> null

yes query differs based on database. which one are you using marcci22

lakshmikandh
Valued Contributor II

Re: Script, sql query: Where .... <> null

Check this one PostgreSQL - NULL Values