Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
FrankGrimm
Partner - Creator
Partner - Creator

Multilinks between 2 tables

Hello together,

 

i have the table

"tablerelation"

RECID TABLE1 RECID_1 TABLE2 RECID_2
1 ADDRESS 24 SALES 3
2 SALES 1 CUSTOMER 4
3 CUSTOMER 55 ADDRESS 22
4 ADDRESS 23 ADDRESS 29
5 CUSTOMER 4 ADDRESS 101

, witch describes how the links between the tabels are 

That meens:

The row 24 in the table ADDRESS is related with the row 3 of the table SALES

The row 1 in the tabel SALES is related with the row 4 of the table CUSTOMER

Attention

The row 23 of ADDRESS is related with the row 29 of ADDRESS

in This case i have 2 relations from one table to another table.

Qlik don´t allow 2 parallel relations between tables. Qlik generate an syntetic index.

FrankGrimm_0-1657785165191.png

How to solve the problem, the to tabels are realated with more then one link?

 

Thanks to all.

Frank

Labels (2)
1 Reply
vinieme12
Champion III
Champion III

can you post some sample data for all 3 tables?

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.