Qualify and unqualify

[#1]

Can someone explain to me the purpose of the Qualify and Unqualify

thanks

kelly

[Miguel_Angel_Baeyens]

Hello Kelly,

What qualify does is to prefix all fields from one table with the name of the table, so all possible relations and links between both will not be performed, as QlikView does that when two fields have the same name.

Should you want to prefix all your fields with the table name, but you want to keep their relations, you may use

unqualify FieldName;

to prevent "FieldName" to be prefixed.

Hope that helps

[#3]

"Qualify", qualifies a field name with the table name. "Unqualify" does not. The purpose is to avoid create relations between field name with the same names that otherwise is done automatically in QlikView.

Example:

Field "Name" in table "Customer" will connect to field "Name" in table "Supplier" if none of them are qualified.

If Qualify is used the field names will be "Customer.Name" and "Supplier.Name" instead an no relation will automatically be created.

[brenner_martina]

Hi,

very helpfull for all key fields is to use a special prefix, p.e. %Keyfield1, %Keyfield2, ... Than you can qualify all fields and unqualify those beginning with %:

Qualify *;

Unqualify '%*';