topic Filter out NULL values in script in App Development

Filter out NULL values in script

TDQlik — Wed, 28 Jul 2021 09:26:41 GMT

Hi,

So I've filtered on certain values in my customer dimension table where wildmatch(FieldA, value1, value2, value3) however, I these values still show up as NULLs in my data for my Sales fact table. I can opt to exclude null values in my pivot table but not in my KPI without a set analysis.

Is there a way that I can exclude these values entirely? Not that they appear as null records in my data.

Any info is appreciated! Thanks

Re: Filter out NULL values in script

MayilVahanan — Wed, 28 Jul 2021 09:47:52 GMT

You are filtered in the dimension table only but not in the sales fact table. So either you can try like below to remove the script.

Hope FieldA occurs in both dimension & fact table.

Inner Keep (Dimtablename)

Load * from yoursalesfacttable;

-----------

or,

Load * from yoursalesfacttable where exists(FieldA);

---------

If you want to do in Front end, try like below

=Sum({<FieldA={"*"}>}Urexpression)

Re: Filter out NULL values in script

TDQlik — Wed, 28 Jul 2021 14:25:39 GMT

Hi Mayil,

Thank you for your assistance. I've managed to figure it out. I loaded my dimension table before my fact table and I used left keep. The field does not appear in the fact table.

[Dimension]:

Load *

FROM dimension

Where FieldA <> Value1;

Fact:

Left Keep (Dimension)

LOAD*

FROM Fact;

Thanks anyway 🙂