3 or more tables are connected with same key

[surajap123]

Hi Experts,

Do i get right results if 3 or more tables are connected with same key field in qlikview like in the picuture?

Is it the right way to design the data model? If no, please tell me how i can avoid this.

Regards,

Suraj

[lukaspuschner]

Hi, you'll get the right resutls

[bbi_mba_76]

Hi,

here a document that could help you

Best Practices for Data Modelling

[MK_QSL]

As far as there are no Syn Table/Key and Circular Reference, you can connect three table with single key.

[its_anandrjs · Accepted solution]

No problem at all but if you follow right data model like star schema with dimension tables will be right way. But for conditions might be some where it is not working so that you attached the key link condition is ok.  But if possible take all table in single table.

[rustyfishbones]

Hi,

You will get the correct results.

A Start Schema is what you should try for, see below

[#7]

Yes you will get the correct results. You can close the unanswered thread with the confirmation