12 Replies Latest reply: May 27, 2018 10:43 AM by Lisa Valpassos RSS

    Not another mixed granularity fact tables...

    Lisa Valpassos

      Hi community   I know this type of question sounds repetitive but I'm really newbie at Qlik and I just need a minimal guidance, because I've read so much techniques and best practices that I'm kind of lost now...

       

      I have the following hierarchies in different files:

       

      Table1:

      Date

      GrandFather

      Father

      Child

      GrandChild

      Fact1

      ...

       

      Table2:

      Date

      Father

      Child

      Fact2

      Fact3

      ...

       

      Table3:

      Date

      GrandFather

      RandomPerson1

      Father

      RandomPerson2,

      RandomPerson3,

      Fact4

      ...

       

      I want to associate the three tables, so I created a composite key (AutoNumber) between Date, Father and Child to associate the first two tables, and it worked fine. In a fact table I have put all the different facts and this key that links the two tables, and dropped the fields from the respective tables. I also have a Master Calendar with the Date key field.

       

      But now I'm tring to do the same thing between table1 and table3, but somehow the Date, GrandFather and Father composite key is not the same in the two tables, so it doesn't link them...

       

      What are the options in terms of modeling this type of situationn? Generic Keys and Link Tables?

       

      Please offer some advice, however trivial it may sound.


      Lisa