How To Resolve Join Errors

[mijileee]

Hi All,

I'm still learning more about Qlik Sense and was wondering if anyone had tips or insights to troubleshooting issues with joins.

When I create key fields to link the tables in my data load editor, I'm not sure how to check whether or not they are joining correctly. I find this even harder when I do a LEFT/OUTER join in my script to pull the necessary data.

Basically, when you notice your joins are incorrect what do you do to fix them?

Thank you!

[rwunderlich]

The first method to validate your joins is to examine the subset ratio of the key fields in the data model viewer. 

https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/DataModeling/preview...

-Rob

[mijileee]

Thanks Rob! The subset ratio should be 100% for all key fields correct?

[rwunderlich · Accepted solution]

Should be 100% inthe DImension table. It may be less than 100% in a Fact table.  For example, consider an Orders fact table that contains 2 years of orders.  Also a Customers table that contains all customers, linked by CustomerId.  In the last 2 years,  only 70% of your customers have placed an order.   Subset Ratio for CustomerId in the Orders table will be 100%, in the Customers table 70%.

-Rob

[mijileee]

Thank you! That example was really helpful.