topic Circular Loop in QlikView

Circular Loop

Thu, 05 Jan 2012 09:14:19 GMT

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!

Circular Loop

vijay_iitkgp — Thu, 05 Jan 2012 09:17:29 GMT

Hi Mars,

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

Regards

VIjay

Circular Loop

Thu, 05 Jan 2012 09:29:44 GMT

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

Circular Loop

Miguel_Angel_Baeyens — Thu, 05 Jan 2012 11:52:35 GMT

Hi,

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

Hope that helps.

Miguel

Re: Circular Loop

Thu, 05 Jan 2012 12:10:42 GMT

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

Circular Loop

Fri, 06 Jan 2012 00:26:25 GMT

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.

Re: Circular Loop

vijay_iitkgp — Fri, 06 Jan 2012 05:53:20 GMT

Hi Mars,

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