topic Re: How to over come Many to Many Relation ship? in QlikView

How to over come Many to Many Relation ship?

Wed, 10 Dec 2014 04:41:08 GMT

Can any one please guide me on how to avoid many to many relation ship between the tables.

Scenario: I have two tables table 1 and table 2 in table 1 contact no is having many contracts as well as Table 2 contract no also having many contact nos ,if i use these tables in qlikview i am getting redundant data. how to handle this scenario.

Re: How to over come Many to Many Relation ship?

Wed, 10 Dec 2014 04:47:21 GMT

hi john,

use qualify *

and unqualify the key field!

Regards,

Barathiraja

Re: How to over come Many to Many Relation ship?

amit_saini — Wed, 10 Dec 2014 04:59:44 GMT

John,

This kind of links will create lots of synthetic key , better to avoid them . check below:

Link

Thanks,

Re: How to over come Many to Many Relation ship?

jonathandienst — Wed, 10 Dec 2014 05:13:54 GMT

The contact table should contain one row per contact with a unique ID (eg ContactID), likewise with the contract table (ContractID). Then use a link table with the fields ContactID and ContractID for the many to many links.

HTH

Jonathan

Re: How to over come Many to Many Relation ship?

sujeetsingh — Wed, 10 Dec 2014 05:26:11 GMT

John,

Dienst has given you the right option well you can use Applymap and joins too to implement the logic.

Re: How to over come Many to Many Relation ship?

Wed, 10 Dec 2014 05:32:09 GMT

Hi Jonathan dienst

If possible can you please explain me with an example.

Thanks

John