how to avoid below model circular join issue?

[devarasu07]

Hi All,

Do you have any idea to resolve below circular join issue. (refer to the attached mock document from below link)

Circular Join Issue? | Qlik Community

[jonathandienst]

The loop is because you have two paths from MaterialMaster (and others to the left) and the Fact table, Associative links have no direction, so this creates a ambiguous situation.

Its tricky to debug this without understanding your data and your intentions. You need a proper design of the data model. Simply aliasing one or more of the ShopNo fields may or may not be the solution. Some of these tables should perhaps be joined, or perhaps you need to bring ShopNo into the Material Master and create a composite key with ShopNo and ArtbatchKey -- but I am just guessing here.

[arvind_patil]

Dear Devarasu,

if Shop No is Unquie field then you have to join

CskJoin table

Join

Csk Vm Stock  holding

Also Join

Stock Min-max

and this link to Fact Table Throw Shop no.

Thanks,

Arvind patil