Breaking Circular Dependencies - Help

[PY]

The attached is a simplified version of multiple tables I needed to import into a data model.

I am having difficulty breaking the number of circular dependencies between the tables. '

Hope someone can give me some guidance on the way forward.... 

[volakakis]

I belive first of all define your dimensions and measures (your fact table). lets start with this

[rahulpawarb]

May be this:

- First you need to identify the joins available between the tables in the data model

- Check can the application leave without any one of them; if yes then remove it; if not then you can go ahead and create alias table using resident load e.g. create separate Demand table for Inventory and PO (make sure to rename to fields to avoid synthetic keys)

If you still have any queries the let me know.

Regards!

Rahul 

[Brett_Bleess]

Might be too simplistic, but wanted to drop you the Help link for resolving them:

https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/LoadData/sol...

Here is a Design Blog post from Henric Cronstrom as well that may be of more help:

https://community.qlik.com/t5/Qlik-Design-Blog/Circular-References/ba-p/1469332

Cheers,
Brett