Data Model Help

[#1]

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.  I'm attaching an image (very scaled down just for discussion) of a relational model.

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).

Obviousy if I load them each as 1 table in Qlikview, I'll get loops.  How do you prevent this??

Thank you very much for the tutorial.

[swuehl]

You can concatenate your two fact tables Dealer_Goal and Orders, having 1 resulting fact table and two dimension tables products and dealers.

See also other threads and blog posts, like e.g.

http://qlikviewnotes.blogspot.de/2009/11/understanding-join-and-concatenate.html