topic Re: Qualifier and Unqualifier. in QlikView

Qualifier and Unqualifier.

Mon, 10 Nov 2014 11:37:24 GMT

when and how to use qualifier and Unqualifier

Re: Qualifier and Unqualifier.

its_anandrjs — Mon, 10 Nov 2014 11:49:34 GMT

Hi,

When you want to rename the table fields with its table name attached we use Qualify or when we use Unqualify it is to not apply function of qualify

LOAD * Inline

[

Name,Address,Region

A,India,APAC

];

QUALIFY *;

UNQUALIFY Name;

LOAD * Inline

[

Name,Sale,Country,Region

A,150000,India,APAC

];

In this two tables Name and Region is common field then if reload this tables it created synthetic keys if not using Qualify because two fields are common in this two tables. But if use qualify all fields rename as TableName.Name, TableName.Sale, TableName.Region when using unqualify Name we do not rename it by using Unqualify and we get association in this two tables with Name field

Previous post i not add such information.

Regards

Anand

Re: Qualifier and Unqualifier.

Mon, 10 Nov 2014 11:55:26 GMT

by using qualify we can make fieldnames are like tablename.fieldname

ex:

sales:

load * inline[

product,

apple

banana

];

if u use qualify like

qualify *;

load * inline[

product,

apple

banan];

then u will get names like product.apple, product.banana

to remove this we will go for unqualify , (i want unqualify for apple) then wright unqualify apple;

finnaly these statements are used to remove synthetic keys and circular reference

final ouput like

sales:

qualify *;

unqualify apple,

load * inline [

product

apple

banana

];

Re: Qualifier and Unqualifier.

Mon, 10 Nov 2014 11:59:54 GMT

Hi,

Qualify means the field which contains prefix with table name.

to avoid the synthetic keys and circuler refferences.

if we are Qualify then we dnt want to do that we can use unqualify.

Qualify *; it shows all fields are prefix with tablename

Qualify ename; it shows only ename field prefix with table name

Re: Qualifier and Unqualifier.

Anonymous — Mon, 10 Nov 2014 12:04:21 GMT

We use them to Avoid Synthetic keys.

When we have more then one same column names in the different table we use Qualify and Unqualify.

Re: Qualifier and Unqualifier.

hic — Mon, 10 Nov 2014 12:05:45 GMT

My view is that you shouldn't use Qualify and Unqualify. These commands make the script more difficult to read and understand (for someone who needs to read and maintain an other developers work). Use proper renaming instead.

Re: Qualifier and Unqualifier.

jagan — Mon, 10 Nov 2014 12:08:53 GMT

Hi,

Qualify comes handy to prevent the Synthetic and Circular loops,

Example:

Personal:

LOAD * Inline

[

Name,Address,Region

A,India,APAC

];

QUALIFY *;

UNQUALIFY Name;

Office:

LOAD * Inline

[

Name,Address,Region

A,150000,India,APAC

];

In the above script when you reload normally the synthetic keys are formed between Name, Address and Region columns, but when you used the above script with Qualify we can avoid the Synthetic keys by renaming the fields Address,Region in Office table like below

Office.Address,Office.Region

Hope this helps you.

Regards,

jagan.

Re: Qualifier and Unqualifier.

mjm — Tue, 11 Nov 2014 14:51:05 GMT

Hello Hammad,

Qualify and Unqualify is a technique to resolve synthetic keys and circular references in a data model. Qualify basically places the table name before the field, e.g tablename.fieldname.

I would advise against using this and consider renaming fields separately as doing this for the whole table will make the ultimate end user experience more difficult to understand what the fields are.

Please mark this answer as helpful and complete if this helps