topic Re: Qualify for Particular tables in QlikView

Qualify for Particular tables

Anonymous — Sun, 03 Apr 2016 07:13:18 GMT

Hi All,

How to use Qualify for Particular tables in Different Tab's.

Thanks,

Krishna

Re: Qualify for Particular tables

HirisH_V7 — Sun, 03 Apr 2016 07:25:33 GMT

We can use QUALIFY and UNQUALIFY to bring in new tables and you want to link on one Common field, Others are Not in common means.

QUALIFY *;

UNQUALIFY Date;

UNQUALIFY OrderID;

Orders:

LOAD OrderID,

Date,

OrderName,

CustomerName,

FROM Table.xls;

UNQUALIFY *;

This will result in a table with fields like this:

OrderID

Date

Orders.OrderName

Orders.CustomerName

Here in the Above table the OrderID and Date Fields are Common and others belonged to Individual Tables.

Post your sample. If Scenario Doesn't look like above.

Hope this helps,

Hirish

Re: Qualify for Particular tables

Kushal_Chawda — Sun, 03 Apr 2016 08:12:41 GMT

Hi,

Qualify statement used to resolve the synthetic keys in tables.

Lets consider the below scenario. You have two table like this

ID,

Date,

Name,

...

FROM table 1

ID,

Date,

Name

FROM table 2

When you load these tables, synthetic key will be generated due to common column ID,Date, Name

But, actual key between two tables is ID only. So there are two ways to resolve synthetic key.

1) Rename the fields which is not required as key

ID,

Date as DateA,

Name as Name A,

...

FROM table 1

ID,

Date as DateB,

Name as NameB

...

FROM table 2;

2) Use Qualify statement like below

Qualify *;

Unqualify ID;

ID,

Date as DateA,

Name as Name A,

...

FROM table 1;

ID,

Date as DateB,

Name as NameB

...

FROM table 2;

Unqualify *;

So here we are unqualifying the ID , rest fields in the table will be qualify which will be renamed like below

tablename.fieldname

So, Table A Fields will be renamed as

A.Date

A.Name

and Table B field will be renamed as

B.Date

B.Name

So finally in both the case table will be linked on ID only.

Re: Qualify for Particular tables

mithilesh17 — Sun, 03 Apr 2016 10:14:44 GMT

Hi,

check this useful thread

Do you Qualify?- How to use QUALIFY statement

Regards,