All you have to do is use Qliks associative modelling to do this. Easiest way is to find a common field within both your sources, and ensure both the Linking field are the same name in both tables. This will create a link between the two tables, and then in the front end you can just add your dimension and measures.
Check if maybe you have more than one name - identical column, because if you have than QlikView will create a systematic key based on a couple of columns and not based on the column you want as a 'Primary Key'.
In this case just change the name of the other identical columns.