Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
darren_dixon
New Contributor III

Join a Dimension table to two Fact tables without causing a loop

Hello,

Problem
Please could you advise the best way to link a Dimension table to two Fact tables without causing a loop.

Currently, the DimRentSubAccount is linked to the FactBalance table. I want to join this with the FactTransaction table.

Desired Outcome

I want to be able to select a Sub Account from DimRentSubAccount and see the results in FactBalance and FactTransaction.

QlikviewExample.PNG

Thanks in advance for your assistance.

Darren

1 Reply
MVP & Luminary
MVP & Luminary

Re: Join a Dimension table to two Fact tables without causing a loop

In this case you should put this field into the link-table.

- Marcus