Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New Contributor

Breaking Circular Dependencies - Help

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

Tags (1)
3 Replies
Highlighted
New Contributor II

Re: Breaking Circular Dependencies - Help

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

Re: Breaking Circular Dependencies - Help

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 

Highlighted
Digital Support
Digital Support

Re: Breaking Circular Dependencies - Help

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.