topic Link table in QlikView

Link table

NavinReddy — Fri, 01 Nov 2013 16:52:07 GMT

Hi All,

Some one help me i Want to know about

Limitations of Link Table

Thanks In Advance

Niranjan

Re: Link table

israrkhan — Fri, 01 Nov 2013 16:59:41 GMT

Hi,

if you go through with this short but in detail with nice example document. you will get all answers about concatenate and Link Table...

Re: Link table

NavinReddy — Fri, 01 Nov 2013 17:17:10 GMT

Hi Israr,

Thanks for giving your valuable suggestion

Re: Link table

Fri, 01 Nov 2013 17:28:11 GMT

Here are some example and explanation

Re: Link table

NavinReddy — Fri, 01 Nov 2013 17:36:01 GMT

Hi Octavio,

Can you please tell me two words about Link Table limitations

Thanks,

Niranjan

Re: Link table

Fri, 01 Nov 2013 17:54:31 GMT

But that limitations are characteristics that must always consider:

• It has the Always use the Distinct keyword to create the link table. This is done so that we are only loading dimension fields in this table must not have duplicate records.

• If the key field is composed of several individual fields can be resource for the application. (In these cases, we can use the Autonumber ()

function described above.)

Re: Link table

Fri, 01 Nov 2013 17:58:52 GMT

Limitations:

• The link table can become very large depending on the number of possible combinations that exist between or among the fields it's composed of.

• If the link table becomes immense, remember that QlikView needs to "walk" through the defined path between tables each time it needs to look for associations. An additional "hop" on this path, especially if it is through a large table, might slow calculation times for the end user.