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?
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%.
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%.
