Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Dalton_Ruer
Support
Support

To Join or Left Join that is the question

As you know Qlik's Associative Model provides easy association of tables by simply "associating" them using a common field name.

 

If you have a lot of dimensional data you probably don't want to have a table pointing to 20 other tables so that your model is cleaner and has fewer "hops." But should you use a plain JOIN or a LEFT JOIN.

 

This video utilizes the General Hospital data set (Click here to get it yourself) ‌to demonstrate an example of a one to one relationship between tables that can be joined together. Narrative explains when a simple JOIN is the right way to go and when a LEFT JOIN should be used instead.

Feel free to download the attached video and watch at your leisure. 

Labels (1)
0 Replies