topic Re: Data model. in QlikView https://community.qlik.com/t5/QlikView/Data-model/m-p/659515#M240583 <HTML><HEAD></HEAD><BODY><P>you have more than one fact tables do there are two way two reduce tables...</P><P></P><P>1. Concatenating the to fact tables</P><P>2. use link table</P><P></P><P>Regards</P><P>vinay</P></BODY></HTML> Fri, 11 Jul 2014 10:45:22 GMT 2014-07-11T10:45:22Z Data model. https://community.qlik.com/t5/QlikView/Data-model/m-p/659513#M240581 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>Please find attached screenshot.</P><P>My FK are in two tables CAl and organisation.</P><P></P><P>Can you please suggest what shall I do for making star schema for this.</P><P></P><P></P><P>thanks,</P><P>Deepak</P></BODY></HTML> Fri, 11 Jul 2014 10:30:42 GMT https://community.qlik.com/t5/QlikView/Data-model/m-p/659513#M240581 deepakqlikview_123 2014-07-11T10:30:42Z Re: Data model. https://community.qlik.com/t5/QlikView/Data-model/m-p/659514#M240582 <HTML><HEAD></HEAD><BODY><P>concatenate the two tables into one</P></BODY></HTML> Fri, 11 Jul 2014 10:32:15 GMT https://community.qlik.com/t5/QlikView/Data-model/m-p/659514#M240582 ali_hijazi 2014-07-11T10:32:15Z Re: Data model. https://community.qlik.com/t5/QlikView/Data-model/m-p/659515#M240583 <HTML><HEAD></HEAD><BODY><P>you have more than one fact tables do there are two way two reduce tables...</P><P></P><P>1. Concatenating the to fact tables</P><P>2. use link table</P><P></P><P>Regards</P><P>vinay</P></BODY></HTML> Fri, 11 Jul 2014 10:45:22 GMT https://community.qlik.com/t5/QlikView/Data-model/m-p/659515#M240583 2014-07-11T10:45:22Z Re: Data model. https://community.qlik.com/t5/QlikView/Data-model/m-p/659516#M240584 <HTML><HEAD></HEAD><BODY><P>Use the link tables for linking two facts otherwise once stage before concate this facts or may be create the single table from both the two tables.</P></BODY></HTML> Fri, 11 Jul 2014 12:59:50 GMT https://community.qlik.com/t5/QlikView/Data-model/m-p/659516#M240584 its_anandrjs 2014-07-11T12:59:50Z Re: Data model. https://community.qlik.com/t5/QlikView/Data-model/m-p/659517#M240585 <HTML><HEAD></HEAD><BODY><P>See the attached</P><P></P><P>good luck</P><P></P><P>Fernando</P></BODY></HTML> Fri, 11 Jul 2014 14:36:04 GMT https://community.qlik.com/t5/QlikView/Data-model/m-p/659517#M240585 fkeuroglian 2014-07-11T14:36:04Z