topic Single fact table by multiple fact tables using Link Table in QlikView https://community.qlik.com/t5/QlikView/Single-fact-table-by-multiple-fact-tables-using-Link-Table/m-p/976804#M649962 <HTML><HEAD></HEAD><BODY><P>Hi I am want to make a single fact table in my data model&nbsp; and i have multiple fact tables in that one to many relationship between both of the tables&nbsp; and i want to make a single fact using Link table by keeping the key fields in Link table and other common&nbsp; dimension fields as well in that. Can any one give me idea how i can achieve that whether i have to join both facts or concatenate it ?? Regards Deepak</P></BODY></HTML> Fri, 04 Sep 2015 13:20:11 GMT 2015-09-04T13:20:11Z Single fact table by multiple fact tables using Link Table https://community.qlik.com/t5/QlikView/Single-fact-table-by-multiple-fact-tables-using-Link-Table/m-p/976804#M649962 <HTML><HEAD></HEAD><BODY><P>Hi I am want to make a single fact table in my data model&nbsp; and i have multiple fact tables in that one to many relationship between both of the tables&nbsp; and i want to make a single fact using Link table by keeping the key fields in Link table and other common&nbsp; dimension fields as well in that. Can any one give me idea how i can achieve that whether i have to join both facts or concatenate it ?? Regards Deepak</P></BODY></HTML> Fri, 04 Sep 2015 13:20:11 GMT https://community.qlik.com/t5/QlikView/Single-fact-table-by-multiple-fact-tables-using-Link-Table/m-p/976804#M649962 2015-09-04T13:20:11Z