topic Re: How to create Link Table?? in QlikView

How to create Link Table??

Tue, 19 Feb 2013 12:42:32 GMT

Hi All,

can any one send me sample example app for how to create Link table.

i read document, but i didn't understand.

Thanks,

Ashok.

Re: How to create Link Table??

spividori — Tue, 19 Feb 2013 14:16:50 GMT

Hi.

See the example.

I have two tables: Purchasing and Sales.

I use a link table to select the fields that are used in both tables.

My English is poor and it is difficult to explain.

Hope this helps.

Regards.

Re: How to create Link Table??

jagannalla — Tue, 19 Feb 2013 14:32:03 GMT

You don't required to link twok tables. Qlikview will automatically link two tables if there is matching column in both tables.

Note: If there is more than one matching column, you will get synthetic keys. Synthetic keys should avoid in qlikview. We can avoid synthetic keys by renaming the fields.

Hope it helps you..

Re: How to create Link Table??

spividori — Tue, 19 Feb 2013 15:24:32 GMT

HI.

I like to use tables links, is more transparent. In a small example may not notice much, but with a large database is much more agile.

Regards.

Re: How to create Link Table??

Wed, 20 Feb 2013 04:51:07 GMT

Hi Sandro,

Thanks for your quick responce. i understood.

Thanks,

Ashok.