How to create Link Table??

[#1]

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.

[spividori · Accepted solution]

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.

[spividori · Accepted solution]

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.

[spividori · Accepted solution]

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.

[spividori · Accepted solution]

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.

[jagannalla]

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..

[jagannalla]

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..

[spividori]

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.

[spividori]

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.

[#10]

Hi Sandro,

             Thanks for your quick responce. i understood.

Thanks,

Ashok.

[#11]

Hi Sandro,

             Thanks for your quick responce. i understood.

Thanks,

Ashok.