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

How to create Link Table??

Hi All,

        can any one send me sample example app for how to create Link table.

i read document, but i didn't understand.

Thanks,

Ashok.

1 Solution

Accepted Solutions
spividori
Specialist
Specialist

Hi.

See the example.

I have two tables: Purchasing and Sales.

I use a link table to select the fields that are used in both tables.

My English is poor and it is difficult to explain.

Hope this helps.

Regards.

View solution in original post

4 Replies
spividori
Specialist
Specialist

Hi.

See the example.

I have two tables: Purchasing and Sales.

I use a link table to select the fields that are used in both tables.

My English is poor and it is difficult to explain.

Hope this helps.

Regards.

jagannalla
Partner - Specialist III
Partner - Specialist III

You don't required to link twok tables. Qlikview will automatically link two tables if there is matching column in both tables.

Note: If there is more than one matching column, you will get synthetic keys. Synthetic keys should avoid in qlikview. We can avoid synthetic keys by renaming the fields.

Hope it helps you..

spividori
Specialist
Specialist

HI.

I like to use tables links, is more transparent. In a small example may not notice much, but with a large database is much more agile.

Regards.

Not applicable
Author

Hi Sandro,

             Thanks for your quick responce. i understood.

Thanks,

Ashok.