Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

How to avoid synthetic table creation and circular references.

Hi everyone ,

If I have 2 fact tables that need to be connected to two same dimensions. In this scenario how can I avoid creation of synthetic tables and circular references.

Thanks.

4 Replies
Not applicable

Re: How to avoid synthetic table creation and circular references.

use concatenate instead. join both into one fact table.

Not applicable

Re: How to avoid synthetic table creation and circular references.

Hi,

you can make Link table to connect tables. In it you need to have Fact1 key, Fact 2 key, Dimension 1 Key and Dimension 2 Key. Also you need to delete Dimension 1 Key and Dimension 2 Key from Fact tables.

EDIT: You can see that http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/17/concatenate-vs-link-table

Best,

Yani

Not applicable

Re: How to avoid synthetic table creation and circular references.

As datulkim have said, join the tables. Then you can add a flag field to identify to which dimension each record belongs.

Not applicable

Re: How to avoid synthetic table creation and circular references.

Hi,

You can use the 'Qualify' in the tables!

Rebeca

Community Browser