topic problem with table LINK in QlikView https://community.qlik.com/t5/QlikView/problem-with-table-LINK/m-p/1275549#M620585 <HTML><HEAD></HEAD><BODY><P>I have two table link table with a same column of other table,&nbsp; I have to make so that this table link 1 link2 connects with the same other table without a table SYN </P></BODY></HTML> Fri, 24 Mar 2017 12:54:07 GMT souadouert 2017-03-24T12:54:07Z problem with table LINK https://community.qlik.com/t5/QlikView/problem-with-table-LINK/m-p/1275549#M620585 <HTML><HEAD></HEAD><BODY><P>I have two table link table with a same column of other table,&nbsp; I have to make so that this table link 1 link2 connects with the same other table without a table SYN </P></BODY></HTML> Fri, 24 Mar 2017 12:54:07 GMT https://community.qlik.com/t5/QlikView/problem-with-table-LINK/m-p/1275549#M620585 souadouert 2017-03-24T12:54:07Z Re: problem with table LINK https://community.qlik.com/t5/QlikView/problem-with-table-LINK/m-p/1275550#M620586 <HTML><HEAD></HEAD><BODY><P>Would you be able to share your data model and explain what is going on?</P></BODY></HTML> Fri, 24 Mar 2017 12:59:28 GMT https://community.qlik.com/t5/QlikView/problem-with-table-LINK/m-p/1275550#M620586 sunny_talwar 2017-03-24T12:59:28Z Re: problem with table LINK https://community.qlik.com/t5/QlikView/problem-with-table-LINK/m-p/1275551#M620587 <HTML><HEAD></HEAD><BODY><P>hello Sunny,</P><P>the script is too long, but i show you a screenshoot, So i have to link OB_LINKTABLE TO AGENCE with the <SPAN style="font-size: 13.3333px;">AGENCE</SPAN>(AGENCEC) <IMG alt="linktable.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/157514_linktable.PNG" style="height: 485px; width: 620px;" /></P></BODY></HTML> Fri, 24 Mar 2017 13:05:02 GMT https://community.qlik.com/t5/QlikView/problem-with-table-LINK/m-p/1275551#M620587 souadouert 2017-03-24T13:05:02Z Re: problem with table LINK https://community.qlik.com/t5/QlikView/problem-with-table-LINK/m-p/1275552#M620588 <HTML><HEAD></HEAD><BODY><P>Are you using QUALIFY * before OB_LinkTable? If you are just add UNQUALIFY AGENCEC; after QUALIFY *;</P></BODY></HTML> Fri, 24 Mar 2017 13:07:15 GMT https://community.qlik.com/t5/QlikView/problem-with-table-LINK/m-p/1275552#M620588 sunny_talwar 2017-03-24T13:07:15Z Re: problem with table LINK https://community.qlik.com/t5/QlikView/problem-with-table-LINK/m-p/1275553#M620589 <HTML><HEAD></HEAD><BODY><P>Without qualify * ; i have problem with SYN TABLE</P><P><IMG alt="linktable.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/157515_linktable.PNG" style="height: 520px; width: 620px;" /></P></BODY></HTML> Fri, 24 Mar 2017 13:12:52 GMT https://community.qlik.com/t5/QlikView/problem-with-table-LINK/m-p/1275553#M620589 souadouert 2017-03-24T13:12:52Z Re: problem with table LINK https://community.qlik.com/t5/QlikView/problem-with-table-LINK/m-p/1275554#M620590 <HTML><HEAD></HEAD><BODY><P>Leave the QUALIFY *, but also add <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">UNQUALIFY AGENCEC;</SPAN></P><P></P><P>So essentially do like this</P><P></P><P><SPAN style="font-size: 13.3333px;"><STRONG>QUALIFY *;</STRONG></SPAN></P><P><STRONG style=": ; color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">UNQUALIFY AGENCEC;</STRONG></P><P></P><P><STRONG>OB_LinkTable:</STRONG></P><P><STRONG>LOAD .....</STRONG></P></BODY></HTML> Fri, 24 Mar 2017 13:26:53 GMT https://community.qlik.com/t5/QlikView/problem-with-table-LINK/m-p/1275554#M620590 sunny_talwar 2017-03-24T13:26:53Z Re: problem with table LINK https://community.qlik.com/t5/QlikView/problem-with-table-LINK/m-p/1275555#M620591 <HTML><HEAD></HEAD><BODY><P>Sunny i found that all others link are deleted <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Fri, 24 Mar 2017 13:38:05 GMT https://community.qlik.com/t5/QlikView/problem-with-table-LINK/m-p/1275555#M620591 souadouert 2017-03-24T13:38:05Z Re: problem with table LINK https://community.qlik.com/t5/QlikView/problem-with-table-LINK/m-p/1275556#M620592 <HTML><HEAD></HEAD><BODY><P>Can you share the screenshot of what happened?</P></BODY></HTML> Fri, 24 Mar 2017 13:39:25 GMT https://community.qlik.com/t5/QlikView/problem-with-table-LINK/m-p/1275556#M620592 sunny_talwar 2017-03-24T13:39:25Z Re: problem with table LINK https://community.qlik.com/t5/QlikView/problem-with-table-LINK/m-p/1275557#M620593 <HTML><HEAD></HEAD><BODY><P>sunny it ok i leave the unqualify with the first table link ,and i put </P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;"><STRONG style="font-style: inherit; font-size: 13.3333px; font-family: inherit;">QUALIFY *;</STRONG></SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit;">UNQUALIFY AGENCEC;</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit;"><BR /></STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit;">with the second link table&nbsp; <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /><BR /></STRONG></P></BODY></HTML> Fri, 24 Mar 2017 13:44:46 GMT https://community.qlik.com/t5/QlikView/problem-with-table-LINK/m-p/1275557#M620593 souadouert 2017-03-24T13:44:46Z Re: problem with table LINK https://community.qlik.com/t5/QlikView/problem-with-table-LINK/m-p/1275558#M620594 <HTML><HEAD></HEAD><BODY><P><IMG alt="link.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/157526_link.PNG" style="height: 356px; width: 620px;" /></P></BODY></HTML> Fri, 24 Mar 2017 14:39:07 GMT https://community.qlik.com/t5/QlikView/problem-with-table-LINK/m-p/1275558#M620594 souadouert 2017-03-24T14:39:07Z Re: problem with table LINK https://community.qlik.com/t5/QlikView/problem-with-table-LINK/m-p/1275559#M620595 <HTML><HEAD></HEAD><BODY><P>So you don't want these 4 columns to connect? or what is the issue?</P></BODY></HTML> Fri, 24 Mar 2017 14:40:34 GMT https://community.qlik.com/t5/QlikView/problem-with-table-LINK/m-p/1275559#M620595 sunny_talwar 2017-03-24T14:40:34Z Re: problem with table LINK https://community.qlik.com/t5/QlikView/problem-with-table-LINK/m-p/1275560#M620596 <HTML><HEAD></HEAD><BODY><P>avoid the SYnt tbale <span class="lia-unicode-emoji" title=":confused_face:">😕</span></P></BODY></HTML> Fri, 24 Mar 2017 14:41:39 GMT https://community.qlik.com/t5/QlikView/problem-with-table-LINK/m-p/1275560#M620596 souadouert 2017-03-24T14:41:39Z Re: problem with table LINK https://community.qlik.com/t5/QlikView/problem-with-table-LINK/m-p/1275561#M620597 <HTML><HEAD></HEAD><BODY><P>You can create composite keys to get rid of synthetic keys.... read here</P><P><A href="https://www.analyticsvidhya.com/blog/2014/11/synthetic-keys-qlikview-simplified/" title="https://www.analyticsvidhya.com/blog/2014/11/synthetic-keys-qlikview-simplified/">https://www.analyticsvidhya.com/blog/2014/11/synthetic-keys-qlikview-simplified/</A></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/157522_Capture.PNG" style="height: 435px; width: 620px;" /></P></BODY></HTML> Fri, 24 Mar 2017 14:44:35 GMT https://community.qlik.com/t5/QlikView/problem-with-table-LINK/m-p/1275561#M620597 sunny_talwar 2017-03-24T14:44:35Z Re: problem with table LINK https://community.qlik.com/t5/QlikView/problem-with-table-LINK/m-p/1275562#M620598 <HTML><HEAD></HEAD><BODY><P>So sunny i can't create direct link ??? i mean that link 1------&gt; lAGENCE / DATESITUATION</P><P>LINK 2 -----&gt; AGENCE /DATE </P><P>WITHOUT PASSING BY SYNTH TABLE</P></BODY></HTML> Fri, 24 Mar 2017 14:50:07 GMT https://community.qlik.com/t5/QlikView/problem-with-table-LINK/m-p/1275562#M620598 souadouert 2017-03-24T14:50:07Z