Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Issues with data model

Hi,

Below I've attached a picture over a universe in Business Objects. I would like to re-create this in QlikView but have problem with how to handle the 2 facts table (F_SoldInsurance and F_PossibleInsurance). All FK to different dates exists only in one of the fact tables (F_SoldInsurance). If I would like to make calculations with measures from both F_SoldInsurance and F_PossibleInsurance and then be able to filter over time what is the best approach here to model this?

Unfortunately it’s not possible to join them. 

TIA  

Universe.PNG

1 Solution

Accepted Solutions
RedSky001
Creator III
Creator III

See the attached file.  I created a link table between the two fact tables...

View solution in original post

6 Replies
sujeetsingh
Master III
Master III

Nothing clear..plz send the sample

Not applicable

Ok, let’s say I have two fact tables and two dimensions:

Fact 1:

PK_Fact1,

FK_Dim1.

FK_Dim2,

FK_Date,

Cost

Fact2:

PK_Fact2,

FK_Dim1,

FK_Dim2,

Budget

Dim1:

PK_Dim1

Dim2:

PK_Dim2

FK_Date (Fact1) will be connected with master calendar and I would like to view different dates.

The fact tables is connected through two dimensions tables.

So If I would like to compare cost (fact1) vs. budget (fact2) or make calculations with these fields what’s the best way to solve this?  

shree909
Partner
Partner

Hi

Fact 1:

PK_Fact1,

FK_Dim1.

FK_Dim2,

FK_Date,

Cost

Fact2:

join(Fact 1)   here ur making the two table to  make an outer join

PK_Fact2,

FK_Dim1,

FK_Dim2,

Budget

Dim1:

PK_Dim1

Dim2:

PK_Dim2

The 2 fact tables are merges as one table and the dimesnions are joined to their respective fields

which will be star schema///

Hope this helps

RedSky001
Creator III
Creator III

See the attached file.  I created a link table between the two fact tables...

View solution in original post

Not applicable

Thanks Shree909,

Unfortunately it’s not possible to join the fact tables, I tried it.

But otherwise that would be a good idea!

Not applicable

Thanks msheraton!

This solution solved the problem.