Remember that Qlik is NOT a relational database, so you cannot simply extract data from a bunch of tables and dump them in Qlik. In your case you will need to design a data model that supports the type of analysis required.
First determine the type of fact (or fact(s)) you need *** what you report ***, and what dimensions you have *** how you want to categorise what you are reporting ***
Select only the fields needed for your model (not select *), work out how the entities in your model are associated, rename fields when the same field in different source tables mean different things. Work out what should be joined to the fact/dimension tables and what should be a table in its own right.
You may still have one tr two composite keys (aka in Qlik as synthetic keys) when you have done this, but they should not be the spider's web of your posted diagram. If they make sense, you may be able to use them as is, or you could create your own concatenated key to replace the synthetic key.
If you have more than one fact table, you may want to concatenate them, or use a link table to associate them correctly.
Search for topics on model design, synthetic/composite keys, link tables and so on for more detailed help.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
