topic Two fact tables - one big dimension table in QlikView https://community.qlik.com/t5/QlikView/Two-fact-tables-one-big-dimension-table/m-p/192667#M54240 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have following scenario:</P><P>I have 2 quite big fact tables with three fields that I want to filter (each one separately).</P><P>My first idea is to create one dimension table. The problem is that when join 3 tables with 120 records each, as a result I would get table with 15625000 records. My application slows down immediately.</P><P>Maybe you have different way of handling this kind of situation?</P><P>Looking forward to hear from you all.</P><P>Kind regards,</P><P>Janusz</P><P></P></BODY></HTML> Thu, 17 Jun 2010 14:31:34 GMT 2010-06-17T14:31:34Z Two fact tables - one big dimension table https://community.qlik.com/t5/QlikView/Two-fact-tables-one-big-dimension-table/m-p/192667#M54240 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have following scenario:</P><P>I have 2 quite big fact tables with three fields that I want to filter (each one separately).</P><P>My first idea is to create one dimension table. The problem is that when join 3 tables with 120 records each, as a result I would get table with 15625000 records. My application slows down immediately.</P><P>Maybe you have different way of handling this kind of situation?</P><P>Looking forward to hear from you all.</P><P>Kind regards,</P><P>Janusz</P><P></P></BODY></HTML> Thu, 17 Jun 2010 14:31:34 GMT https://community.qlik.com/t5/QlikView/Two-fact-tables-one-big-dimension-table/m-p/192667#M54240 2010-06-17T14:31:34Z Two fact tables - one big dimension table https://community.qlik.com/t5/QlikView/Two-fact-tables-one-big-dimension-table/m-p/192668#M54241 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I would build a link table that sits in the middle of all the tables,</P><P>There are various discussions on the community relatig to link tables, here is one of them:</P><P><A href="http://community.qlik.com/forums/t/16164.aspx">http://community.qlik.com/forums/t/16164.aspx</A></P><P>Search for Link Table on the community to get more.</P><P></P></BODY></HTML> Thu, 17 Jun 2010 14:55:58 GMT https://community.qlik.com/t5/QlikView/Two-fact-tables-one-big-dimension-table/m-p/192668#M54241 2010-06-17T14:55:58Z