topic 2 fact tables in QlikView

2 fact tables

Mon, 24 Mar 2014 01:13:27 GMT

I have two fact tables, which are linked based on ID. In fact table1, I have 100 ID's and in Fact Table2, I have 50 ID's. I am linking Territory to Fact Table2. Now the problem is I have to show all 100 ID's at Territory level but I just have 50ID's in the Fact Table2 where Terr is linked.

Thanks

Re: 2 fact tables

chiru_thota — Mon, 24 Mar 2014 01:35:31 GMT

Hi Pramod,

I guess your scenario seems as shown in the below screenshot.

(1) Soultion 1: Join both Fact1 and Fact2 on ID.

So that you will have single table and all the records will have Teritory_ID to connect to Dim_Terr table

(2) Solution2: Get Teritory_ID into Fact1 from Fact2 by joining on column ID.

So that Fact1 table will have Territory_ID to connect to Dim_Terr.

Re: 2 fact tables

Mon, 24 Mar 2014 01:49:54 GMT

Thankyou, I can't join any table in the data model. The data model is already complex.

Re: 2 fact tables

chiru_thota — Mon, 24 Mar 2014 02:52:40 GMT

Ok.

I guess you can take all the ID's in Fact1 table and concatenate to table Fact2.

Ex:

Load * from Fact2;

concatenate

Load ID resident Fact1;