Multiple table joins

[#1]

Hi Guys

Could someone please help me with this scenario:

Say I have 3 tables:

Project:

Project ID

Project Name

Year

Cost

Cost ID

Cost Name

Year

Sales

Sales ID

Sales Name

Year

When I join all 3 by Year, I get an error below.

One or more loops have been detected in your database structure. Loops may cause ambiguous results and should therefore be avoided. QlikView will cut the loop(s) by setting one or more tables as loosely coupled. Settings for loosely coupled tables can be modified after script execution in the tables page of the document properties dialog.

Just need to join them for criteria on the QVW.

Please help

[srinivasa1]

i think you can try with qulifier load as well.

[#3]

i think you need to revise your structure..

try to concatenate those 3 tables and create a new table.. then connect your new table to MasterCalendar table over Year column..

BR

Omer

[richard_chilvers]

It seems we are all agreed, you need to think carefully about your data structure.

QlikView will do its best to work it out (as you have seen) but your results will be unpredictable.

Regards

Richard