Discussion board where members can learn more about Qlik Sense App Development and Usage.
I want to join two fact tables (sale and targets) using two keys but it is making a circular reference.
qvf is attached for your reference.
You already seem to have a valid data model with no circular reference connecting the Sales and Target tables in a valid way... So could you explain a bit more about which fields you need to use and how the tables would have "new" fields to enable maybe a target on a customer level?
if you want to compare different fact values (actual and budget) you have to load them into ONE fact table.
You can achieve this by concatenate (table) load
In your case, you have actual on customer an target on territory. This won't work by concatenate only.
So you have to load actual, join territory by customer into actual table and then concatenate load target.
then you will have one table with
and you can create a chart with actual and target by territory.
Thank you Martinpohl,
Can i achieve the same using Link table as in real scenario i have many dimensions linked with both fact tables. so i made a simple one just to understand the solution to such problems.
Taking so many tables in one using concatenate also reduces performance.