topic Re: Linking Tables in Qlikview in QlikView

Linking Tables in Qlikview

Mon, 11 Jan 2016 12:52:20 GMT

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,

Re: Linking Tables in Qlikview

sinanozdemir — Mon, 11 Jan 2016 14:34:29 GMT

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

Re: Linking Tables in Qlikview

Anonymous — Mon, 11 Jan 2016 14:41:37 GMT

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

Re: Linking Tables in Qlikview

Peter_Cammaert — Mon, 11 Jan 2016 14:41:54 GMT

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

Re: Linking Tables in Qlikview

Mon, 11 Jan 2016 15:38:30 GMT

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.

Re: Linking Tables in Qlikview

Peter_Cammaert — Mon, 11 Jan 2016 17:02:59 GMT

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

Re: Linking Tables in Qlikview

Mon, 11 Jan 2016 19:33:04 GMT

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