topic Unable to link two transactional tables through a Link Table in QlikView https://community.qlik.com/t5/QlikView/Unable-to-link-two-transactional-tables-through-a-Link-Table/m-p/1236743#M393273 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I'm having trouble linking two of my tables using a Link Table.&nbsp; I've attached some screenshots to show how they are supposed to link.&nbsp; One is the 'Orders' table and the other is the 'Competitor' table. </P><P></P><P>As you can see by the first image (FK_Calendar), I have pulled in the date from the competitor table and assigned this as FK_Calendar.&nbsp; This is also how FK_Calendar is assigned in the Orders table.&nbsp; However, the tables do not link in the main application.&nbsp; The other attached images show the data model, the Link Table, and a group of list boxes.&nbsp; The list boxes show that, even though SKU is associated with Competitor, Orders are not pulled through, despite SKU being associated with orders.</P><P></P><P>Anyone know what I can do?</P><P></P><P>Cheers.</P></BODY></HTML> Tue, 21 Feb 2017 15:53:47 GMT Anonymous 2017-02-21T15:53:47Z Unable to link two transactional tables through a Link Table https://community.qlik.com/t5/QlikView/Unable-to-link-two-transactional-tables-through-a-Link-Table/m-p/1236743#M393273 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I'm having trouble linking two of my tables using a Link Table.&nbsp; I've attached some screenshots to show how they are supposed to link.&nbsp; One is the 'Orders' table and the other is the 'Competitor' table. </P><P></P><P>As you can see by the first image (FK_Calendar), I have pulled in the date from the competitor table and assigned this as FK_Calendar.&nbsp; This is also how FK_Calendar is assigned in the Orders table.&nbsp; However, the tables do not link in the main application.&nbsp; The other attached images show the data model, the Link Table, and a group of list boxes.&nbsp; The list boxes show that, even though SKU is associated with Competitor, Orders are not pulled through, despite SKU being associated with orders.</P><P></P><P>Anyone know what I can do?</P><P></P><P>Cheers.</P></BODY></HTML> Tue, 21 Feb 2017 15:53:47 GMT https://community.qlik.com/t5/QlikView/Unable-to-link-two-transactional-tables-through-a-Link-Table/m-p/1236743#M393273 Anonymous 2017-02-21T15:53:47Z