topic help in data modeling in QlikView https://community.qlik.com/t5/QlikView/help-in-data-modeling/m-p/93767#M605425 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have two fact tables and 5 dimension tables. Fact tables should not be linked. What is the better approach to design the data model?</P><P>As of now, I have designed by joining the dimension tales to fact tables. But in the application, I have charts from both fact tables and filters from dimension tables. Now the problem is I have to pass the dimension filed selections to respective fields to both the fact tables since the fact tables are connected, could anyone guide me on this?</P><P></P><P>Regards,<BR />Shruthi</P></BODY></HTML> Tue, 17 Jul 2018 06:25:51 GMT shruthibk 2018-07-17T06:25:51Z help in data modeling https://community.qlik.com/t5/QlikView/help-in-data-modeling/m-p/93767#M605425 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have two fact tables and 5 dimension tables. Fact tables should not be linked. What is the better approach to design the data model?</P><P>As of now, I have designed by joining the dimension tales to fact tables. But in the application, I have charts from both fact tables and filters from dimension tables. Now the problem is I have to pass the dimension filed selections to respective fields to both the fact tables since the fact tables are connected, could anyone guide me on this?</P><P></P><P>Regards,<BR />Shruthi</P></BODY></HTML> Tue, 17 Jul 2018 06:25:51 GMT https://community.qlik.com/t5/QlikView/help-in-data-modeling/m-p/93767#M605425 shruthibk 2018-07-17T06:25:51Z Re: help in data modeling https://community.qlik.com/t5/QlikView/help-in-data-modeling/m-p/93768#M605426 <HTML><HEAD></HEAD><BODY><P>Hi Shruthi,</P><P></P><P>As per My thought process you need to add link table.</P><P></P><P>For more detail please provide sample data in excel .</P><P></P><P>Thanks &amp; Regards,</P><P>Arvind Patil</P></BODY></HTML> Tue, 17 Jul 2018 08:52:16 GMT https://community.qlik.com/t5/QlikView/help-in-data-modeling/m-p/93768#M605426 arvind_patil 2018-07-17T08:52:16Z