Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

not equal to in QVD generator

SQL

SELECT

*
FROM PUB.invanal

where analysis-cat not in('d','c','f');

When I use this, its removing the records with blank values also.

Is there any way to avoid it?

1 Solution

Accepted Solutions
MVP
MVP

Re: not equal to in QVD generator

Hi Nick,

Are you sure it is blank values, not NULLs?

You could try the following:

WHERE (analysis-cat IS NULL OR analysis-cat NOT IN ('d','c','f'));

Hope that helps,

Steve

1 Reply
MVP
MVP

Re: not equal to in QVD generator

Hi Nick,

Are you sure it is blank values, not NULLs?

You could try the following:

WHERE (analysis-cat IS NULL OR analysis-cat NOT IN ('d','c','f'));

Hope that helps,

Steve

Community Browser