topic Re: Qlualify * ; in QlikView

Qlualify * ;

Thu, 15 Nov 2012 00:07:28 GMT

Hey guys

A quick one: in script, what is the meaning of

Qualify *;

unqualify *;

Thanks a lot~~~~~~~~~~~~

Gloria

Thu, 15 Nov 2012 00:27:10 GMT

Qualify is a keyword that is used to 'qualify' the field names with the tablename. If you have something like:

Qualify *;

Unqualify EmpID;

Employees:

Load

EmpID,

FirstName,

LastName

From <source>

will result in

Employees.FirstName

Employees.Lastname

and since you Unqualified EmpID it will remain EmpID. - and will not be Employees.EmpID

You can use EmpID as a key to link the Employees dimension to the fact table in your data model.

Thu, 15 Nov 2012 01:31:20 GMT

Hi there

Thank you so much!! the example is understandable!!

Cool~

Gloria