Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Tags (2)
2 Replies
Not applicable

Data Model Loop Problem

The last bullet in my question was a typo

Data Model Loop Problem

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,

Community Browser