topic Re: 3 or more tables are connected with same key in QlikView

3 or more tables are connected with same key

surajap123 — Mon, 28 Apr 2014 08:18:58 GMT

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

Re: 3 or more tables are connected with same key

lukaspuschner — Mon, 28 Apr 2014 08:20:28 GMT

Hi, you'll get the right resutls

Re: 3 or more tables are connected with same key

bbi_mba_76 — Mon, 28 Apr 2014 08:21:38 GMT

Hi,

here a document that could help you

Best Practices for Data Modelling

Re: 3 or more tables are connected with same key

MK_QSL — Mon, 28 Apr 2014 08:28:52 GMT

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

Re: 3 or more tables are connected with same key

its_anandrjs — Mon, 28 Apr 2014 08:30:13 GMT

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.

Re: 3 or more tables are connected with same key

rustyfishbones — Mon, 28 Apr 2014 08:31:02 GMT

Hi,

You will get the correct results.

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

Re: 3 or more tables are connected with same key

Mon, 28 Apr 2014 08:52:15 GMT

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