Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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.