Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My data model was working fine until I added a new table agency_month_target. It created a circular reference and a sync key. the fact_sales_agg table is the main table that was linking everything else. This is how my data model looks like right now. If I need to build a link table which tables do I need to link together?
I think it's either a link table or concatenating your fact tables:
https://community.qlik.com/t5/Qlik-Design-Blog/Fact-Table-with-Mixed-Granularity/ba-p/1468238
https://community.qlik.com/t5/QlikView-Documents/Generic-keys/ta-p/1496560
https://livingqlikview.com/link-table-vs-concatenation-case-mixed-granularity/