topic Re: how to avoid below model circular join issue? in QlikView

how to avoid below model circular join issue?

devarasu07 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

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

Re: how to avoid below model circular join issue?

jonathandienst — Mon, 10 Jul 2017 04:57:46 GMT

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.

Re: how to avoid below model circular join issue?

arvind_patil — Mon, 10 Jul 2017 05:44:21 GMT

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