topic Re: Link table in QlikView

Link table

prabhas277 — Thu, 11 Feb 2016 06:09:48 GMT

Hi experts,

what is the link table? when we go for link table? explain with example?

Re: Link table

Chanty4u — Thu, 11 Feb 2016 06:12:00 GMT

Hi prabhas,

chk below link

https://community.qlik.com/message/862718#862718

Re: Link table

prma7799 — Thu, 11 Feb 2016 06:25:15 GMT

Please check below

how to create link table in Qlikview?

Re: Link table

HirisH_V7 — Thu, 11 Feb 2016 06:32:05 GMT

Hi,

Links tables are used In Qlikview,When You come across a situation where you have to handle multiple Fact tables, which in turn create synthetic keys or Circular references(Loops).

Link Table is a very useful way to resolve synthetic keys and Circular references(Loops) when multiple fact tables are present in the data model.

Link table is used, when the granularity of the facts tables are different and when they are joined to different dimensions.

To resolve these synthetic keys Link table:

You should always load Distinct records while creating Link table. Also if the Key field/composite field contains several individual fields then it is good to create Key field
Create a composite key. Using Auto number ( ) function like:
AutoNumber(YEAR&’|'&CUSTOMER_KEY&’|'&PRODUCT_KEY) As [%Key field]
Link table can connect to the original fact tables using this composite Key
Load all the common fields in one table called Link table
Drop these fields from the original tables.

HTH,

Hirish

Re: Link table

jagan — Thu, 11 Feb 2016 06:42:04 GMT

Hi,

Check thsi link

how to create link table in Qlikview?

Link Table in QlikView | Learn QlikView

http://www.analyticsvidhya.com/blog/2014/12/remove-synthetic-key-concatenation-link-table-qlikview/

Re: Link table

avinashelite — Thu, 11 Feb 2016 07:57:50 GMT

check this link for the complete inforamtion

Link Table in QlikView | Learn QlikView