topic Re: Many to many relationship in Qlik in QlikView

Many to many relationship in Qlik

abdul_mo — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Many to many relationship in Qlik

Tanalex — Wed, 27 Jun 2018 16:47:02 GMT

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

Re: Many to many relationship in Qlik

honeyasha — Wed, 27 Jun 2018 17:00:24 GMT

Hi Abdul

You can use Link table if you have multiple fact table.

In Link table we have many to many relationship.

Re: Many to many relationship in Qlik

narayanamsn — Wed, 27 Jun 2018 18:48:25 GMT

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/

Re: Many to many relationship in Qlik

abdul_mo — Thu, 28 Jun 2018 06:57:28 GMT

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.

Re: Many to many relationship in Qlik

BalaBhaskar_Qlik — Thu, 28 Jun 2018 14:22:43 GMT

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.