topic Re: Data Model Help in QlikView https://community.qlik.com/t5/QlikView/Data-Model-Help/m-p/390698#M145700 <HTML><HEAD></HEAD><BODY><P>You can concatenate your two fact tables Dealer_Goal and Orders, having 1 resulting fact table and two dimension tables products and dealers.</P><P></P><P>See also other threads and blog posts, like e.g.</P><P><A class="loading" href="http://qlikviewnotes.blogspot.de/2009/11/understanding-join-and-concatenate.html" title="http://qlikviewnotes.blogspot.de/2009/11/understanding-join-and-concatenate.html">http://qlikviewnotes.blogspot.de/2009/11/understanding-join-and-concatenate.html</A></P></BODY></HTML> Wed, 27 Feb 2013 23:55:07 GMT swuehl 2013-02-27T23:55:07Z Data Model Help https://community.qlik.com/t5/QlikView/Data-Model-Help/m-p/390697#M145699 <HTML><HEAD></HEAD><BODY><P>I keep getting confused on how best to work the data model in Qlik 11. I hear talk about ways to do it but I learn best from examples.&nbsp; I'm attaching an image (very scaled down just for discussion) of a relational model.</P><P></P><P><IMG __jive_id="34007" class="jive-image-thumbnail jive-image" onclick="" alt="dbdesign.jpg" src="https://community.qlik.com/legacyfs/online/34007_dbdesign.jpg" width="450" /></P><P></P><P>In this example, you have dealers, products, orders (dealer orders made up of products) and dealer_goal (count or qty goal for a dealer of each product).</P><P></P><P>Obviousy if I load them each as 1 table in Qlikview, I'll get loops.&nbsp; How do you prevent this??</P><P></P><P>Thank you very much for the tutorial.</P></BODY></HTML> Wed, 27 Feb 2013 20:20:33 GMT https://community.qlik.com/t5/QlikView/Data-Model-Help/m-p/390697#M145699 2013-02-27T20:20:33Z Re: Data Model Help https://community.qlik.com/t5/QlikView/Data-Model-Help/m-p/390698#M145700 <HTML><HEAD></HEAD><BODY><P>You can concatenate your two fact tables Dealer_Goal and Orders, having 1 resulting fact table and two dimension tables products and dealers.</P><P></P><P>See also other threads and blog posts, like e.g.</P><P><A class="loading" href="http://qlikviewnotes.blogspot.de/2009/11/understanding-join-and-concatenate.html" title="http://qlikviewnotes.blogspot.de/2009/11/understanding-join-and-concatenate.html">http://qlikviewnotes.blogspot.de/2009/11/understanding-join-and-concatenate.html</A></P></BODY></HTML> Wed, 27 Feb 2013 23:55:07 GMT https://community.qlik.com/t5/QlikView/Data-Model-Help/m-p/390698#M145700 swuehl 2013-02-27T23:55:07Z