topic Re: Where clause removing NULL values in QlikView

Where clause removing NULL values

Fri, 28 Nov 2014 11:56:25 GMT

I am having a problem whereby I am using a Where clause to exclude any products that have their product description marked as EXCLUDED but the problem is that the where clause is also excluding any new products that have not yet been allocated...so they have NULL values as their product description.

Does anyone have any suggestions of how to stop that from happening?

Thanks

Re: Where clause removing NULL values

Gysbert_Wassenaar — Fri, 28 Nov 2014 11:58:50 GMT

LOAD *

FROM ...somewhere...

WHERE [Product description] <> 'EXCLUDED' or len(trim([Product description])) = 0;

If you're using an sql statement you probably need something like

SELECT *

FROM ...somewhere...

WHERE "Product description" <> 'EXCLUDED' or "Product description" IS NULL;

Re: Where clause removing NULL values

bbi_mba_76 — Fri, 28 Nov 2014 12:02:24 GMT

Hi,

I don't know if you are talking about a where using sql or a load. But I think you could use something like

where (len(description)=0 or match(description,'EXCLUDED')<>1)

If it is an sql then you have to change the clauses using is null

where (description is null or description<>'EXCLUDED' )

Re: Where clause removing NULL values

Colin-Albert — Fri, 28 Nov 2014 12:09:37 GMT

Can you post the section of your script with the where clause. That will help to give you the correct answer.

Re: Where clause removing NULL values

Fri, 28 Nov 2014 12:30:22 GMT

Thanks that worked