topic Re: what is use of link tables ,how to use it in QlikView

what is use of link tables ,how to use it

sakamsureshbabu — Thu, 18 Sep 2014 05:13:44 GMT

we can use link table as a fact table.

Re: what is use of link tables ,how to use it

Thu, 18 Sep 2014 05:21:44 GMT

Link tables are generally used for linking the two table or the fact tables. With the use of link tables, it’s possible to keep the fact tables separated from each other. The advantage of this solution for choosing this method is to keep the data model a logical one. With the use of link tables, it’s possible to keep the fact tables separated from each other.

and go through this link and please close the thread

How To: Prevent Circular Reference in a Qlikview Data Model » Quick – Qlear – Qool

Re: what is use of link tables ,how to use it

sibideepak — Thu, 18 Sep 2014 05:22:45 GMT

Hi sakamsureshbabu ,

Follow the link ..

What is Link Tables? What is the use?

How to create Link Table??

Re: what is use of link tables ,how to use it

avinashelite — Thu, 18 Sep 2014 05:23:33 GMT

Hi Suresh,

In Qlikview you can link the tables using only one key, if we try to connect using two it will create synthetic key.

To avoid this we go for link table i.e. is to combine the tables using 2 keys