topic Re: Link tables together on multiple fields in QlikView https://community.qlik.com/t5/QlikView/Link-tables-together-on-multiple-fields/m-p/717566#M1074529 <HTML><HEAD></HEAD><BODY><P>You can try the following:</P><P></P><P>To the UserTransaction table join Date1 from RegisteredUser table and then create a composite key with TransactionID and Date in both Transaction and UserTransaction table to link them</P><P></P><P>Thanks</P></BODY></HTML> Tue, 05 Aug 2014 17:18:14 GMT 2014-08-05T17:18:14Z Link tables together on multiple fields https://community.qlik.com/t5/QlikView/Link-tables-together-on-multiple-fields/m-p/717565#M1074528 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>Please see attached a partial view of my table structure. I have some tables linked on Date1 <SPAN style="font-size: 10pt; line-height: 1.5em;">and some linked on the user_id, however the Transaction table, bottom left, also has a 'Transaction Date' field which i would like to link to 'Date1'. This however will cause a circular link issue.</SPAN></P><P></P><P>How would i structure / link the transaction table so that i can filter by Date1 in my graphs and have the data out of the transaction table display accordingly.</P><P></P><P>Thanks</P><P>JP </P><P></P><P><IMG alt="Screen Shot 2014-08-05 at 14.23.54.png" class="jive-image" src="/legacyfs/online/63738_Screen Shot 2014-08-05 at 14.23.54.png" style="width: 620px; height: 724px;" /></P></BODY></HTML> Tue, 05 Aug 2014 13:39:16 GMT https://community.qlik.com/t5/QlikView/Link-tables-together-on-multiple-fields/m-p/717565#M1074528 2014-08-05T13:39:16Z Re: Link tables together on multiple fields https://community.qlik.com/t5/QlikView/Link-tables-together-on-multiple-fields/m-p/717566#M1074529 <HTML><HEAD></HEAD><BODY><P>You can try the following:</P><P></P><P>To the UserTransaction table join Date1 from RegisteredUser table and then create a composite key with TransactionID and Date in both Transaction and UserTransaction table to link them</P><P></P><P>Thanks</P></BODY></HTML> Tue, 05 Aug 2014 17:18:14 GMT https://community.qlik.com/t5/QlikView/Link-tables-together-on-multiple-fields/m-p/717566#M1074529 2014-08-05T17:18:14Z