Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
surajap123
Creator III
Creator III

3 or more tables are connected with same key

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.

4 tables joining on same key.png

Regards,

Suraj

1 Solution

Accepted Solutions
its_anandrjs

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.

View solution in original post

6 Replies
lukaspuschner
Partner - Creator
Partner - Creator

Hi, you'll get the right resutls

bbi_mba_76
Partner - Specialist
Partner - Specialist

Hi,

here a document that could help you

Best Practices for Data Modelling

MK_QSL
MVP
MVP

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

its_anandrjs

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
Master II
Master II

Hi,

You will get the correct results.

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

2014-04-28_0930.png

Not applicable

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