Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Link tables together on multiple fields

Hi All

Please see attached a partial view of my table structure. I have some tables linked on Date1 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.

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.

Thanks

JP

Screen Shot 2014-08-05 at 14.23.54.png

1 Reply
Not applicable
Author

You can try the following:

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

Thanks