topic Re: Many to Many in QlikView

Many to Many

NavinReddy — Tue, 04 Feb 2014 11:01:52 GMT

Dear All,

I have Two Facts(Sales,Gross)tables

between two facts many to many relationships we have what is the best way to create data model

Thanks In Advance

Niranjan

Re: Many to Many

Peter_Cammaert — Tue, 04 Feb 2014 11:10:02 GMT

Make a link table with two fields: a key to Facts1 and a key to Facts2. Fill the link table with all possible relations between the two.

If your facts tables have common dimension fields, moe those fields to the link table as well.

Good luck,

Peter

Re: Many to Many

Gysbert_Wassenaar — Tue, 04 Feb 2014 11:11:10 GMT

Create a third table that links the other two. And make sure the two fact tables don't have fields with the same name or Qlikview will link the fact tables too.

Re: Many to Many

senpradip007 — Tue, 04 Feb 2014 11:16:07 GMT

Hi.

Create a link table with a particular Field Name of two facts table. Then link other master tables with the link table.