Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
souadouert
Specialist
Specialist

problem with table LINK

I have two table link table with a same column of other table,  I have to make so that this table link 1 link2 connects with the same other table without a table SYN

1 Solution

Accepted Solutions
sunny_talwar

Leave the QUALIFY *, but also add UNQUALIFY AGENCEC;

So essentially do like this

QUALIFY *;

UNQUALIFY AGENCEC;

OB_LinkTable:

LOAD .....

View solution in original post

13 Replies
sunny_talwar

Would you be able to share your data model and explain what is going on?

souadouert
Specialist
Specialist
Author

hello Sunny,

the script is too long, but i show you a screenshoot, So i have to link OB_LINKTABLE TO AGENCE with the AGENCE(AGENCEC) linktable.PNG

sunny_talwar

Are you using QUALIFY * before OB_LinkTable? If you are just add UNQUALIFY AGENCEC; after QUALIFY *;

souadouert
Specialist
Specialist
Author

Without qualify * ; i have problem with SYN TABLE

linktable.PNG

sunny_talwar

Leave the QUALIFY *, but also add UNQUALIFY AGENCEC;

So essentially do like this

QUALIFY *;

UNQUALIFY AGENCEC;

OB_LinkTable:

LOAD .....

View solution in original post

souadouert
Specialist
Specialist
Author

Sunny i found that all others link are deleted

sunny_talwar

Can you share the screenshot of what happened?

souadouert
Specialist
Specialist
Author

sunny it ok i leave the unqualify with the first table link ,and i put

QUALIFY *;

UNQUALIFY AGENCEC;


with the second link table 

souadouert
Specialist
Specialist
Author

link.PNG