topic Re: FACT table in QlikView https://community.qlik.com/t5/QlikView/FACT-table/m-p/1143643#M374438 <HTML><HEAD></HEAD><BODY><P>Depends on how many rows of data are you expecting the FACT table to contain, are you going to do any count(Distinct ) calculations</P><P></P><P>Join your fact table one by one to see operational efficiency ...as long as you don't see any lag in your dashboard you should be fine...if you do then split your table again.</P></BODY></HTML> Sun, 07 Aug 2016 18:30:22 GMT vinieme12 2016-08-07T18:30:22Z FACT table https://community.qlik.com/t5/QlikView/FACT-table/m-p/1143642#M374437 <HTML><HEAD></HEAD><BODY><P>Hi Community</P><P></P><P>Quick question about FACT tables.&nbsp; If I have a data model with tables that consist of different levels of granularity, can these tables all be combined into 1 fact table?</P><P>For example:-</P><UL><LI>Table 1 - Main table1</LI><LI>&nbsp; Table A - Main order detail (multiple lines of the table 1)</LI><LI>Table B - Details of the Main order details&nbsp; (multiple lines of table A)</LI></UL><P></P><P>Is it OK to combine table A and B into 1 fact table?</P><P></P><P></P><P>Thanks Community</P><P></P><P>Let me know if you need any more detail</P></BODY></HTML> Sun, 07 Aug 2016 14:07:20 GMT https://community.qlik.com/t5/QlikView/FACT-table/m-p/1143642#M374437 2016-08-07T14:07:20Z Re: FACT table https://community.qlik.com/t5/QlikView/FACT-table/m-p/1143643#M374438 <HTML><HEAD></HEAD><BODY><P>Depends on how many rows of data are you expecting the FACT table to contain, are you going to do any count(Distinct ) calculations</P><P></P><P>Join your fact table one by one to see operational efficiency ...as long as you don't see any lag in your dashboard you should be fine...if you do then split your table again.</P></BODY></HTML> Sun, 07 Aug 2016 18:30:22 GMT https://community.qlik.com/t5/QlikView/FACT-table/m-p/1143643#M374438 vinieme12 2016-08-07T18:30:22Z