Linking Tables in Qlikview

[#1]

I have three separate tables that I have retrieved from a QVD. How do I link these tables together, and where do I do it.

Many thanks,

T.

[sinanozdemir]

Hi,

You do all of your data modelling in the edit script, shortcut is Ctrl + E. If you can post your QVDs or your app here, someone will definitely help you.

Thanks

[Anonymous]

You need to do some training.  QV is very intuitive once you get started.  Here is a link to get you going

New to QlikView Videos

Also do a search on the Resource Library and you will find an abundance of information

[Peter_Cammaert]

You link them together by creating associations. Basically this is done in one of two ways:

• name columns the same in tables you want to combine (e.g. existing fields), or
• create composite keys from multiple columns in two (or three) tables and give them thesame name (new fields)

Best,

Peter

[#5]

Hi Peter,

Thank you for your answer. What syntax that I need to use for a relationship in Qlikview? I currently have three tables - Order, Vehicle & Location - lets say I have a location ID in each table I.E. the location table has an auto-numeric ID as its primary key which identifies the rest of the row, with an order using that ID as a way to find which location the order has been placed at and the vehicle has the location ID to show which store it belongs to.

[Peter_Cammaert · Accepted solution]

In script editor, use the wizards (Insert menu) to generate simple LOAD statements for each of the three QVD's. For each one, you will get a dialog that allows you to choose which columns to load and which ones to skip. Clicking on a column name allows you to rename this column.

Make sure that you rename all Location ID columns (one in each table) to the same name.

Execute the load script. QlikView will automatically associate the three tables based on a single common field.

Make sure that no other fields exist in more than one table (rename them to block association)

Peter

[#7]

Hi T R,

You just need to rename the fields you want to link.

Table A:

User_Cod,

User_Name

Table B:

User_Cod,

Age

This code will link this two tables by User_Cod just because they have same name.

It's a little bit different if you are thinking in Database like Oracle, MySQL...

Same Name = Link

Giba