Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Read a lot about circular references but still stuck on a problem.
There's a lot of tables in the model but essentially the issue is between three tables:
1. Extracted Job Data - this includes:
2. FTE Breakdown- this includes:
3. Fund mapping - this includes:
I figure I can deal with the max (both) model using set analysis but I can't figure out how to get my joins right:
Some notes on the links:
Been scratching my head over this for too long now. Any thoughts of how I can fix?
Hi Lisa,
I'm not sure how I'd use a link table unless I did something like Month-DBCode, which would be really difficult to maintain.
Is there more information I can provide to help better explain the problem?
Thanks,
Thomas
The problem with circular references is that because the Qlik Sense engine is always trying to understand the relationships in the data, this scenario may give ambiguous results and therefore one of the tables will become loosely coupled and may result in incorrect results in your visualizations. Therefore this ambiguity must be resolved.
Hi Lisa,
Thanks for your response.
I've through a lot on circular references as it is a common issue in the forums but I still am having trouble figuring out how to actually setup my schema in scalable way. The only options I can think of at the moment are:
1. Create a DBCode-Month link table; or
2. Output model as a field in the Extracted Job Data dataset
I'm hoping there's a better solution available than either of the above.
Agreed....Qlik Sense engine is always trying to understand relationships in data..Can't agree more than it