topic Re: how to create a link table in QlikView

how to create a link table

michael_maeuser — Fri, 17 Feb 2012 08:09:05 GMT

Hi, I have many tables in my data model. If I link all tables to the calendar i get many syn tables and circular references. Now i want to solve the problem with a link table. i googled a lot but still don´t understand how to do that exactly. For example I have 5 tables: Vendors (Fields: %Vendor,Name etc.) , Vendor ledger entry (%Vendor, Amount, Posting Date, item), Customer (Fields: %Vendor,Name etc.), Customer ledger entry (%Debitor, Amount, Posting Date, item) and Calendar. By the way I have also som left joins in my script. Is it true that I have to avoid them if I work with link tables?Thanks! Michael

how to create a link table

vijay_iitkgp — Fri, 17 Feb 2012 08:29:09 GMT

Hi ,

If you can share your current table view then it will be easy for us to ynderstand.

Re: how to create a link table

michael_maeuser — Fri, 17 Feb 2012 08:34:47 GMT

see attached...

Re: how to create a link table

CELAMBARASAN — Fri, 17 Feb 2012 09:09:40 GMT

Hi,

Try with this approach

Make a key with the fields which creates synthetic key and change that fields names to be differ in both the table.You can use qualify instead of changing the field names.

For Example:

Load Field1&Field2 as Key, Field1, Field2..From..

Load Field1&Field2 as Key, Field1 as Field3, Field2 as Field4..From..

Which makes the key to link between 2 tables.

Hope it helps

Celambarasan