See this example
Is one of the most comon way to eliminate Circular reference, cut all the relation between tables and create a only table linked by all the others table
In the event of multiple fact tables QlikView In-Memory Technology allows us to create a central link table that only contains the existing data combinations. Instead of Joining the tables the event dimensions can be merged (CONCATENATED) in to one central Link table. This link table can then be linked back to the event measures one side and
the dimension tables on the other.
Please find sample for the same,
By the use of Link table we remove the synthetic key and circular reference,
we can also remove synthetic key and circular reference by using join, concatenate, change alias.
but by link table no need of join, concatenate, change alias.
simply you create another table which is linked with table that is called Link table.
When you have multiple Fact tables in QlikView, it can be handled in 2 ways, by using concatenate or by using Link tables. If the granularity and columns in the fact tables are same then you can useConcatenate which will merge the tables into one and resulting table will have the sum of rows of the twotables.