table relation

[praveenkumar_s]

i want to establish a relationship between two table in qlikview...anybody tell me how to do it in qlik view....

[rupamjyotidas]

There will be many topics on the community, you can search for them . Also below link would help you

https://help.qlik.com/en-US/

[johnw]

Name a field the same in both tables.

Say you have an orders table an a customers table. Orders are placed by customers. Say your customer field in the orders table is [Ordered By] and the one in the customers table is [Customer ID]. These tables will not link up. You will need to rename one of the fields to match the other. Then they will be linked properly.

[Anil_Babu_Samineni]

1) By using AutoField

2) Give same Field name using Qualify , Un-Qualify

T1:

Load *, Rowno() as TR;

Load A, B, C from T1;

T2:

Load *, Rowno() as TR;

Load D, E, F from T2;

Then Use Ctrl + T and See whether relation produced or not