Circular Loop

[#1]

Hi,

I have a problem with circular loop. In my schema I have 3 fact tables, Sales, Returns and Budget. I already created a link table but after I build the link table it produced a circular loop. I think CustomerId is responsible for the circular loop.

I hope you can help me on this issue. Attached is a sample QlikView file and its source.

Thank you very much!

[vijay_iitkgp]

Hi Mars,

If you have alreay taken CustomerId in Link Table then rename it in other tables with different Name.

Regards

VIjay

[#3]

Alias is not the solution because it should still be connected to the link table and customer type table

[Miguel_Angel_Baeyens]

Hi,

You can concatenate Budget, Sales and Returns table into one bigger table, as in this post.

Hope that helps.

Miguel

[#5]

Hi balcita,

The attached application is the correct data model for your problem.

You don't need the typeid to connect from budget to customertype table, as it is already linked to it through the linktable.

Hope it helps.

BR,

Abhinava

[#6]

Hi everyone,

Thank you for your reply,

@Abhinava Chandra: Sir, the result of your data model is:

I think the customerId for transaction B1 - B3 shouldn't be null?

Thank you.

[vijay_iitkgp]

Hi Mars,

Please try attached qvs file. Hope fully thtis will help.