topic What is the use of link table? in QlikView

What is the use of link table?

Tue, 15 Sep 2015 06:04:18 GMT

Hi to all the experts in qlik view,

I wan to clearly understand the concept of link table,can anyone help me out.

Thanks

Harshitha

Re: What is the use of link table?

prma7799 — Tue, 15 Sep 2015 06:07:18 GMT

Hi Harshita,

Please go through below link

what is use of link tables ,how to use it

link table

What is Link Tables? What is the use?

Thanks

Re: What is the use of link table?

gautik92 — Tue, 15 Sep 2015 06:07:26 GMT

in case you have two or more fact tables with some common fields you can concatenate the tables to form a link table whic act as fact table

Re: What is the use of link table?

engishfaque — Tue, 15 Sep 2015 06:08:50 GMT

Dear Harshitha,

Please look into,

link table

Concatenate vs Link Table

how to create link table in Qlikview?

Link Table in QlikView | Learn QlikView

Kind regards,

Ishfaque Ahmed

Re: What is the use of link table?

Tue, 15 Sep 2015 06:09:11 GMT

Hi Gowtham,

we cant use them as separate tables.

Re: What is the use of link table?

senpradip007 — Tue, 15 Sep 2015 06:10:15 GMT

You can go through this thread link table

Re: What is the use of link table?

gautik92 — Tue, 15 Sep 2015 06:11:11 GMT

there cant be two fact tables

Re: What is the use of link table?

yadav_anil782 — Tue, 15 Sep 2015 06:12:42 GMT

Hi Harshita,

for join more then 1 fact table we use link table -

plz visit this link- Qlik Tips: Rules for creating a Key/Link Table in QlikView

http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/17/concatenate-vs-link-table

Re: What is the use of link table?

gautik92 — Tue, 15 Sep 2015 06:15:45 GMT

in star schema you will be having oly on fact table

Re: What is the use of link table?

Tue, 15 Sep 2015 06:16:39 GMT

Hi,

Thank you guys for your quick response and time.

Regards

Harshitha

Re: What is the use of link table?

Kushal_Chawda — Tue, 15 Sep 2015 06:18:35 GMT

Link table is called as 'Factless Fact' in data warehouse term in which you have only dimensional keys.

When you have two Fact tables with many to many relationship we create a link table to connect two Fact tables.

For example see the below link

https://community.qlik.com/thread/132848

Re: What is the use of link table?

qlikmsg4u — Tue, 15 Sep 2015 06:19:43 GMT

One more

Advantages of Link Table;

Re: What is the use of link table?

Tue, 15 Sep 2015 06:20:00 GMT

Thank you Kush i understood the importance of link table.

Regards

Re: What is the use of link table?

Nagaraju_KCS — Tue, 15 Sep 2015 07:09:32 GMT

Hi,

* When there are common fields in multiple tables (a synthetic key exists) but most of the fields

from each table are not shared.

* It is a table that stores all possible combinations of values.

* When there is more than one field in common between tables.

* Use: To maintain integrity of your application.