Key Fields

[#1]

I have a script with several select statements.

There are similar column names in the script.

First Question:

I want to decide which columns are key columns and which are not

Second Question:

Is it possible to define the relations between two queries by myself. It could be possible that the name of the columns with the relation are not the same.

[Gysbert_Wassenaar]

Qlikview associates tables using the fields that the tables have in common. These are the key fields. You can decide what names you give fields and so you get to determine how tables are associated. Just make sure that the fields that should be used to link the table get the same name. Qlikview is case sensitive so KEY, Key and key are three different names.

[Clever_Anjos]

Qlikview "way of doing relations" is using same column names as keys, that simple.

If you don´t want a column to be used as key rename it to another name