Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Linking Tables in Qlikview

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.

1 Solution

Accepted Solutions
Peter_Cammaert
Partner - Champion III
Partner - Champion III

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

View solution in original post

6 Replies
sinanozdemir
Specialist III
Specialist III

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
Not applicable
Author

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
Partner - Champion III
Partner - Champion III

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

Not applicable
Author

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
Partner - Champion III
Partner - Champion III

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

Not applicable
Author

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