Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Link table with different dimensions for different Facts

Hello,

I am trying to find out if it is possible to create a link table which will have 2 Fact tables with similar dimensions and keys, while the third Fact will not have the same set of dimension keys. is it possible to create a separate composite key just to connect the fact2 and fact3? Or is it possible to use the same key created for the Fact1 and 2 for joining Fact3 as well.

LinkTable.JPG

Thanks.

Tags (1)
3 Replies
MVP & Luminary
MVP & Luminary

Re: Link table with different dimensions for different Facts

Yes, you can create a Link Table that connects different Facts with difference granularity levels. You will need to generate two Combo keys - one with all three common keys and another one with only the two common keys. Fact1 and Fact2 will be joined by the first key, while Fact3 will be joined by the second key.

I'm describing this kind of a data model with a lot of detail in my book QlikView Your Business.

cheers,

OlegTroyansky

Partner
Partner

Re: Link table with different dimensions for different Facts

Hi Oleg,

could you please help me creating a link table.

Hi have:

T1:

ID_T

...

T2:

ID_A

ID_T

...

T3:

ID_R

ID_A

...

T4:

ID_R

ID_T

...

T5:

ID_R

I found big problems creating my Link Table.

I tried many times in different ways but no results.

Could you please help me

best regards

Giampiero

Highlighted
federerman
New Contributor III

Re: Link table with different dimensions for different Facts

Oleg, can you go into a bit more detail on why two combo keys are necessary, as opposed to a single key?