Table viewer issue

[#1]

I have two tables in my table viewer and it automatically created a link between them two fields with the same name.  However, the tables are not linked that way.  I have tried everything to delete the link and create the link the tables between the correct fields.  What am I doing wrong?

[#2]

I figured it out.  In the script editor, I needed to change the field names by using the "as newfieldname" in the script editor to be the same name.

[martinpohl · Accepted solution]

you are right.

QlikView create a links between same field name(s)

If you don't want that they be linked, rename them with "as" to different names,

if the fields you want to link have different names you have to rename at least one like the field from first table.

Also, QlikView wants only one linked field between tables, so if a unique identification is only possible by many fields, you have to combine them with "&" to one single field.

In one table you should use the combines filed with single information for select.

Regards

[#4]

Thanks for the extra tidbit about linking multiple fields.  I am sure I will run into that in the future.