topic Breaking Circular Dependencies - Help in QlikView

Breaking Circular Dependencies - Help

PY — Fri, 01 Mar 2019 09:43:57 GMT

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....

Re: Breaking Circular Dependencies - Help

volakakis — Fri, 01 Mar 2019 10:17:37 GMT

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

Re: Breaking Circular Dependencies - Help

rahulpawarb — Fri, 01 Mar 2019 10:51:21 GMT

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

Re: Breaking Circular Dependencies - Help

Brett_Bleess — Mon, 04 Mar 2019 16:21:50 GMT

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/solve-circular-references.htm

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