Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

what is use of link tables ,how to use it

we can use link table as a fact table.

1 Solution

Accepted Solutions
Not applicable

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

View solution in original post

3 Replies
Not applicable

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

View solution in original post

Creator II
Creator II

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