topic Re: Issues with data model in QlikView https://community.qlik.com/t5/QlikView/Issues-with-data-model/m-p/461881#M698658 <HTML><HEAD></HEAD><BODY><P>See the attached file.&nbsp; I created a link table between the two fact tables...</P></BODY></HTML> Mon, 28 Jan 2013 16:55:22 GMT RedSky001 2013-01-28T16:55:22Z Issues with data model https://community.qlik.com/t5/QlikView/Issues-with-data-model/m-p/461877#M698654 <HTML><HEAD></HEAD><BODY><P style="margin-bottom: .0001pt;"><SPAN lang="EN-US" style="font-size: 10pt; font-family: Arial, sans-serif;">Hi,</SPAN></P><P><SPAN lang="EN-US" style="font-size: 10pt; font-family: Arial, sans-serif;"> </SPAN></P><P><SPAN lang="EN-US" style="font-size: 10pt; font-family: Arial, sans-serif;">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? </SPAN></P><P style="margin-bottom: .0001pt;"><SPAN lang="EN-US" style="font-size: 10pt; font-family: Arial, sans-serif;">Unfortunately it’s not possible to join them.&nbsp; </SPAN></P><P><SPAN lang="EN-US" style="font-size: 10pt; font-family: Arial, sans-serif;"> </SPAN></P><P><SPAN style="font-size: 10pt; font-family: Arial, sans-serif;">TIA&nbsp;&nbsp; </SPAN></P><P></P><P></P><P><IMG __jive_id="32235" class="jive-image-thumbnail jive-image" height="478" onclick="" alt="Universe.PNG" src="https://community.qlik.com/legacyfs/online/32235_Universe.PNG" style="width: 908px; height: 478.2133333333333px;" width="908" /></P></BODY></HTML> Mon, 28 Jan 2013 09:47:26 GMT https://community.qlik.com/t5/QlikView/Issues-with-data-model/m-p/461877#M698654 2013-01-28T09:47:26Z Re: Issues with data model https://community.qlik.com/t5/QlikView/Issues-with-data-model/m-p/461878#M698655 <HTML><HEAD></HEAD><BODY><P>Nothing clear..plz send the sample</P></BODY></HTML> Mon, 28 Jan 2013 09:53:54 GMT https://community.qlik.com/t5/QlikView/Issues-with-data-model/m-p/461878#M698655 sujeetsingh 2013-01-28T09:53:54Z Re: Issues with data model https://community.qlik.com/t5/QlikView/Issues-with-data-model/m-p/461879#M698656 <HTML><HEAD></HEAD><BODY><P>Ok, let’s say I have two fact tables and two dimensions:</P><P></P><P>Fact 1:</P><P>PK_Fact1,</P><P>FK_Dim1.</P><P>FK_Dim2,</P><P>FK_Date,</P><P>Cost</P><P></P><P>Fact2:</P><P>PK_Fact2,</P><P>FK_Dim1,</P><P>FK_Dim2,</P><P>Budget</P><P></P><P></P><P>Dim1:</P><P>PK_Dim1</P><P></P><P>Dim2:</P><P>PK_Dim2</P><P></P><P>FK_Date (Fact1) will be connected with master calendar and I would like to view different dates. </P><P>The fact tables is connected through two dimensions tables.</P><P></P><P>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?<SPAN style="font-size: 10pt;">&nbsp;&nbsp; </SPAN></P></BODY></HTML> Mon, 28 Jan 2013 16:24:01 GMT https://community.qlik.com/t5/QlikView/Issues-with-data-model/m-p/461879#M698656 2013-01-28T16:24:01Z Re: Issues with data model https://community.qlik.com/t5/QlikView/Issues-with-data-model/m-p/461880#M698657 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>Fact 1:</P><P>PK_Fact1,</P><P>FK_Dim1.</P><P>FK_Dim2,</P><P>FK_Date,</P><P>Cost</P><P></P><P>Fact2:</P><P>join(Fact 1)&nbsp;&nbsp; here ur making the two table to&nbsp; make an outer join</P><P>PK_Fact2,</P><P>FK_Dim1,</P><P>FK_Dim2,</P><P>Budget</P><P></P><P></P><P>Dim1:</P><P>PK_Dim1</P><P></P><P>Dim2:</P><P>PK_Dim2</P><P></P><P></P><P>The 2 fact tables are merges as one table and the dimesnions are joined to their respective fields</P><P>which will be star schema///</P><P></P><P>Hope this helps</P></BODY></HTML> Mon, 28 Jan 2013 16:54:51 GMT https://community.qlik.com/t5/QlikView/Issues-with-data-model/m-p/461880#M698657 shree909 2013-01-28T16:54:51Z Re: Issues with data model https://community.qlik.com/t5/QlikView/Issues-with-data-model/m-p/461881#M698658 <HTML><HEAD></HEAD><BODY><P>See the attached file.&nbsp; I created a link table between the two fact tables...</P></BODY></HTML> Mon, 28 Jan 2013 16:55:22 GMT https://community.qlik.com/t5/QlikView/Issues-with-data-model/m-p/461881#M698658 RedSky001 2013-01-28T16:55:22Z Re: Issues with data model https://community.qlik.com/t5/QlikView/Issues-with-data-model/m-p/461882#M698659 <HTML><HEAD></HEAD><BODY><P>Thanks Shree909,</P><P></P><P>Unfortunately it’s not possible to join the fact tables, I tried it.</P><P></P><P>But otherwise that would be a good idea!</P></BODY></HTML> Mon, 28 Jan 2013 22:29:44 GMT https://community.qlik.com/t5/QlikView/Issues-with-data-model/m-p/461882#M698659 2013-01-28T22:29:44Z Re: Issues with data model https://community.qlik.com/t5/QlikView/Issues-with-data-model/m-p/461883#M698660 <HTML><HEAD></HEAD><BODY><P style="margin-bottom: .0001pt;"><SPAN lang="EN-US" style="font-size: 10pt; font-family: Arial, sans-serif;">Thanks msheraton!<SPAN> </SPAN></SPAN></P><P><SPAN lang="EN-US" style="font-size: 10pt; font-family: Arial, sans-serif;"> </SPAN></P><P><SPAN lang="EN-US" style="font-size: 10pt; font-family: Arial, sans-serif;">This solution solved the problem.</SPAN></P></BODY></HTML> Mon, 28 Jan 2013 22:31:27 GMT https://community.qlik.com/t5/QlikView/Issues-with-data-model/m-p/461883#M698660 2013-01-28T22:31:27Z