Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello everyone,
I am a new Qliker and I have a general question.
let suppose we have two tables with a common field called Artikel (not a primary key in both tables).
if we load these tables in qlik sense/view, the qlik engine will link them using this common field.
do we have a calculation problem in this case, in which we have many to many relationship?
Regards.
Yes, Qlik will link on any column(s) with the same name. If this is a true many to many relationship, you may need a bridge table to resolve to one to many.
Data Warehouse Design Techniques – Bridge Tables – NuWave Solutions
Hi Abdul
You can use Link table if you have multiple fact table.
In Link table we have many to many relationship.
Here is the reference for LINK table concept where you have multiple FACT tables...
http://www.qlikfix.com/2016/09/08/elegant-link-table-script/
thanks Michael for your answer. that means we will stuck anyway in a calculation problem if we do not use a link table( bridge table). I thought or I would prefer that the qlik engine smart enough to discover this many to many relationship and take it into account in calculation.
Regards.
May be like this:
You can join the tables, calculate NEW FIELDS, after that if you want you can DROP the common fields from the tables.