Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
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
jagan
MVP
MVP

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
pablolabbe
Luminary Alumni
Luminary Alumni

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

Not applicable
Author

‌We use pervasive.

rupamjyotidas
Specialist
Specialist

Might Help:

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

viveknair1234
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

jagan
MVP
MVP

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

lakshmikandh
Specialist II
Specialist II

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

lakshmikandh
Specialist II
Specialist II

Check this one PostgreSQL - NULL Values