link table

[nag78936]

what is granularity at differnt level?

when should we use link table?

[salonicdk28]

See the blog for granularity 

 http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/26/mixed-granularity

Link table is used in a data model when you have multiple fact tables to handle

As we know that when we are designing the data model, synthetic keys and circular loop are common.

For fixing this problems we use the link table.

some other link for reference-

Link Table in QlikView | Learn QlikView

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

Qlik Tips: Rules for creating a Key/Link Table in QlikView

[vikasmahajan]

Hi,

Here is a detail explaination with demo for Link table.

https://community.qlik.com/t5/Qlik-Sense-Documents/link-table/ta-p/1883375