Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Aspiring_Developer
Specialist
Specialist

Data model with 2 fact tables

Hi team,

I have below scenario:-

Aspiring_Developer_0-1627365416928.png

I have created dimensions table and linked it with referenced table like below:-

LET vDimension = 'DIM_PROJECT_DIVISION';$(vDimension):
LOAD
ref_id as %DivisionId,
ref_title as [Division Name]
FROM [...]
(qvd)
WHERE ref_type = 'DIVISION_NEW';

//--------------------------------------------------------------------------

LET vDimension = 'DIM_User_Department';

$(vDimension):
LOAD
ref_id as %OrganizationLevel1Id,
ref_title as [Department Name]

FROM
[...]
(qvd)
where ref_type ='ORG_LEVEL_1_NEW';

//---------------------------------------------------------

LET vDimension = 'DIM_User_Service';

$(vDimension):
LOAD
ref_id as %OrganizationLevel2Id,
ref_title as [Service Name]

FROM
[...](qvd)
where ref_type ='ORG_LEVEL_2_NEW';

//---------------------------------------------------------------------------------------

User:

Load 

orga_level_1 as %OrganizationLevel1Id,

division as %DivisionId ,
service_id as %OrganizationLevel2Id
From [....User.qvd](qvd);

 

Card: Load division as %DivisionId,
orga_level_1 as %OrganizationLevel1Id,
orga_level_2 as %OrganizationLevel2Id

From[....Card.qvd](qvd);

//-----------------------------------------------------------------------------------------

So, i have kind of two fact tables in the above model.

I tried to create link table approach , however it didn't worked because it breaks the link with dimension table like below:-

Aspiring_Developer_2-1627366450545.png

 

Can anyone please help me how to resolve this issue ? Please help .

Thank you

0 Replies