Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
TDQlik
Contributor II
Contributor II

Filter out NULL values in script

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

1 Solution

Accepted Solutions
TDQlik
Contributor II
Contributor II
Author

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 🙂

 

View solution in original post

2 Replies
MayilVahanan

Hi

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)

Thanks & Regards,
Mayil Vahanan R
TDQlik
Contributor II
Contributor II
Author

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 🙂