topic Re: don't filter null values in QlikView

don't filter null values

surajap123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am using exists() to filter the data from 2nd table. However i don't want to filter out the row if the value is null.

Stock:

LOAD Material

FROM

data.xlsx

(ooxml, embedded labels, table is Stock);

Sales:

LOAD Product,

Sales

FROM

data.xlsx

(ooxml, embedded labels, table is Sales)

where exists(Material,Product);

Please help.

daveamz — Tue, 06 Jun 2017 06:58:38 GMT

Hi Suraj,

where exists(Material,Product) OR IsNull(Product)

Regards,

David

tresB — Tue, 06 Jun 2017 06:59:21 GMT

May be like:

....

FROM

data.xlsx

(ooxml, embedded labels, table is Sales)

where exists(Material,Product) OR IsNull(Product);

surajap123 — Tue, 06 Jun 2017 07:04:02 GMT

Awesome.:)

Thanks everyone.