Many to Many

[NavinReddy]

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

[Peter_Cammaert]

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

[Gysbert_Wassenaar]

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.

[senpradip007]

Hi.

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