Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

multiple fact tables

Hi Friends,

I have the following table structure:

Fact tables:

LatexCollection

---------------

Date                               FieldNo                Empno                 LAT

01/04/2010            1                   W001                    10

TreesPlanation

--------------

Date                              FieldNo                         Tree_Planted               Tree_Lost

30/04/2010               1                              1000                                        30

30/05/2010               2                              6000                                        100

Dimension tables:

FieldMaster

-----------

FieldNo                         Name

1                                   F2010

2                                   F2009

Calendar

--------

Date                                   Year                    Month

01/04/2010               2010               apr

Can anybody suggest how to make relationship among these tables.

regards and thanks

chandan

11 Replies
johnw
Champion III
Champion III

In the example in the linked thread, the DateType field and set analysis are only required to handle the case where a single key field has more than one date field associated with it, and we want to preserve that information.

I see nothing wrong with your example, but it isn't designed to handle that case.

simpler requirement = simpler solution

Not applicable
Author

Hi John,

Thanks for your reply. I understood clearly by your explaination why my solution won't work when multiple dates are associated with single key field. We have to use date type in link table and set operator to distinguish between two dates.

Thanks,

Anosh