Discussion Board for collaboration related to QlikView App Development.
ProblemPlease 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.
I want to be able to select a Sub Account from DimRentSubAccount and see the results in FactBalance and FactTransaction.
Thanks in advance for your assistance.
In this case you should put this field into the link-table.