Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP & Luminary
MVP & Luminary

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.

View solution in original post

7 Replies
Highlighted
Luminary
Luminary

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

Highlighted
Not applicable

‌We use pervasive.

Highlighted
Specialist
Specialist

Might Help:

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

Highlighted
Contributor III
Contributor III

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

Highlighted
MVP & Luminary
MVP & Luminary

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.

View solution in original post

Highlighted
Specialist II
Specialist II

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

Highlighted
Specialist II
Specialist II

Check this one PostgreSQL - NULL Values