topic Re: DataModelling in QlikView https://community.qlik.com/t5/QlikView/DataModelling/m-p/797676#M281744 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>&nbsp; You will use <STRONG>concatenate</STRONG> may you will get good result.</P></BODY></HTML> Fri, 13 Mar 2015 08:08:12 GMT 2015-03-13T08:08:12Z DataModelling https://community.qlik.com/t5/QlikView/DataModelling/m-p/797674#M281742 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>PFA.</P><P></P><P>I have total 8 fact tables.</P><P>4 is for row indicators and 4 for derive indicators.</P><P>Tables are same there structure is also same.</P><P>In data modelling side only concatenation for 8 fact tables will be better or not.</P><P>What will happen if i can use join.</P><P></P><P>Please advice.</P></BODY></HTML> Fri, 13 Mar 2015 07:05:45 GMT https://community.qlik.com/t5/QlikView/DataModelling/m-p/797674#M281742 deepakqlikview_123 2015-03-13T07:05:45Z Re: DataModelling https://community.qlik.com/t5/QlikView/DataModelling/m-p/797675#M281743 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>&nbsp;&nbsp; If Dimensions are same then go for concatenate because if u use join that will effect on your application performance</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; concatenate it will append the data table by table</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Join it will&nbsp; add filed data in side by side</P><P></P><P></P><P>Thank</P><P>Manju</P></BODY></HTML> Fri, 13 Mar 2015 07:14:11 GMT https://community.qlik.com/t5/QlikView/DataModelling/m-p/797675#M281743 2015-03-13T07:14:11Z Re: DataModelling https://community.qlik.com/t5/QlikView/DataModelling/m-p/797676#M281744 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>&nbsp; You will use <STRONG>concatenate</STRONG> may you will get good result.</P></BODY></HTML> Fri, 13 Mar 2015 08:08:12 GMT https://community.qlik.com/t5/QlikView/DataModelling/m-p/797676#M281744 2015-03-13T08:08:12Z