Re : Linking Issue

[#1]

Hi All,

I Have a table with current year project information,another table with billing&collection data and i have my Budget table.

nw the issue is i have to link this 3 tables and to make a report which contains the Current Year project details and Previous year details along with the billing details as expressions.

in CY project information table  i hav project id,prev year project key. This project key has to be linked to billing & collection table [project id] to get the previous year project.

and current year [project id] should be again linked to the Project ID of Billing collection data to gt the CY project details.

How can it be achieved.

Please suggest.

[puttemans]

Hello Reena,

If you load your three tables, and you make sure that you have only 1 link through a variable name between your CY table and the 2 other tables, then you will be fine.

It is possible you need to create a new key between them (variable1&'|'&variable2 as Key)

[Roop]

If you ensure that the linking fields have identical names (including upper and lower case), QlikView will do the link for you. It will automatically link fields with the same name. If this is not happening, it means that your project id is named differently in your tables or Excel files.