Match between multiples columns in differents tables

[Fab93]

Hi,

To my app I have multiples tables. One, "FAP", have the column "EAQS", the second, "GASR" with the column "Risque 1", the third "Match" with the match columns between "EAQS" and "Risque 1". I can't join this three tables because they are joined to other tables :

I want connect this tables for use this two graphs together (when I select "Risque 1" in the left graph, the right graph show the match "EAQS")   :

Do you have any idea how I can do this ? I think use set analysis but dont know how to start.

You can can find the waited result in "Good result.qvf" and the work apply ("Work.qvf") attached to this message.

Thank for your help !

[Vinicius_121]

You can use data load script to load your data, and rename Risque 1 TC on 'Match' table to match the colunm name 'GASR 1.Risque 1' on 'GASR' table, this will create the link you need.

See this article about data load script, it might help you.

https://help.qlik.com/en-US/sense/November2021/Subsystems/Hub/Content/Sense_Hub/LoadData/use-data-lo... 

[Fab93]

Hi Vinicius-121,

I cannot use this solution. I have to link the "FAP" and "GASR" table to the "Match" table, without breaking the links already present. If I create a direct link between these tables, it will create a cycle which is not a good practice does not work.

See: 

[Vinicius_121]

Hello Fab93,

Do you need the link between the tables "GARS Detail" and "FAP Detail"? The table match wouldn't do the job of linking them?

[Fab93]

Hello,

Yes, I need the link between "GASR detail" and "FAP Detail".