topic table relation in QlikView

table relation

praveenkumar_s — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: table relation

rupamjyotidas — Mon, 17 Oct 2016 18:50:24 GMT

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/

Re: table relation

johnw — Mon, 17 Oct 2016 18:58:44 GMT

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.

Re: table relation

Anil_Babu_Samineni — Tue, 18 Oct 2016 02:58:57 GMT

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