Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data Model Loop Problem

I am new to QlikView and struggling with how to handle this loop problem.

  • fact data is at the product and customer level.
  • Market lookup
  • Market to Product Xref
  • Territory LooKup
  • Territorty to Custoemr Xref

So Far so Good. Now the Issue. there are some legal reasons some territorys can not see customers in some markets, but they can see them in others.

  • Market to Customer to Terrirtory Xref

This creates a loop and I am not sure how to handle this

  • Also a relation ship between a Territory and

fsdfsdafOther Fields1

2 Replies
Not applicable
Author

The last bullet in my question was a typo

Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

The best solution depends on your analytic needs and on the meaning of those Xref tables, but in any case, you are going to de-normalize and include more attributes in your Fact Table. For example:

Left-Join Market-To-Project Xref into the Fact and eliminate the Xref

Left-Join Territory-to-Customer into the Fact and eliminate the second Xref.

Now you need to take care of the third Xref... I'm not quite sure what's the meaning of it, so I'll leave it up to you to decide... It looks like knowing the Product and the Customer from the Fact Table, you can determine the Market and the Territory from the two Xref tables. What's the third Xref table for??? When you answer this question, you'll know how to properly model it...

cheers,