topic Re: qualify and unqualify in QlikView

qualify and unqualify

Fri, 03 Jun 2011 05:30:19 GMT

please explain the qulify and unqualify

reddy

qualify and unqualify

Fri, 03 Jun 2011 05:34:02 GMT

Refer to page No. 323 and 340 of Qlikview reference manual.

qualify and unqualify

Fri, 03 Jun 2011 05:39:22 GMT

Hi,

Qualify statements renames all the fields with the table name prefix which are mentioned in the statement.

QUALIFY *; it can be used above the table name. * is to rename all the field name in the table.

Otherwise u can also specify each field that u wanted to rename.

UNQUALIFY is reverse process of QUALIFY statement.

If u r not using the UNQUALIFY statement after using QUALIFY, it ll rename all fields of all the table below the QUALIFY.

QUALIFY *; //or QUALIFY OrderID, CustomerName;

Orders: //Table Name

LOAD OrderID,

OrderName,

CustomerName,

FROM xxx.xls;

UNQUALIFY *;

If u use * then, ur fields ll be like this: Orders.OrderID

Orders.OrderName

Orders.CustomerName

If not using *, it ll rename oly the fields u have mentioned.

Hope this helps u.

Re: qualify and unqualify

davidwhite — Thu, 01 Nov 2012 03:27:01 GMT

Here's a good way to use QUALIFY and UNQUALIFY to bring in new tables and you want to link on one known field, but you aren't sure whether you will have name clashes with the rest.

QUALIFY *;

UNQUALIFY OrderID;

Orders:

LOAD OrderID,

OrderName,

CustomerName,

FROM xxx.xls;

UNQUALIFY *;

This will result in a table with fields like this:

OrderID

Orders.OrderName

Orders.CustomerName

Re: qualify and unqualify

Thu, 10 Oct 2013 08:40:35 GMT

vey good post. Thank you for give a very clear sample .

Re: qualify and unqualify

Thu, 10 Oct 2013 08:56:35 GMT

Please refer the attached application

Re: qualify and unqualify

datanibbler — Thu, 10 Oct 2013 09:02:49 GMT

Hi,

just to add a little bit out of my own experience:

=> You have to be really careful about those commands: When you have INCREMENTAL LOADs anywhere, for example, putting those commands in the wrong place can have you facing ever-increasing field_names getting longer with every reload

>>> (like [table].[table].[table].[field] etc.) <<<

So it's better to sit back and spend some time thinking what you have (base_data), what you want and what will be the effect of putting those commands in a specific place - and check the outcome right away.

Best regards,

DataNibbler

Re: qualify and unqualify

Wed, 07 Oct 2015 13:32:29 GMT

Nice and helpful post

Re: qualify and unqualify

Wed, 16 Mar 2016 18:06:45 GMT

Hi,

What's the difference between your script and the below one? I did not write UNQUALIFY * at the end.

QUALIFY *;

UNQUALIFY OrderID;

Orders:

LOAD OrderID,

OrderName,

CustomerName,

FROM xxx.xls;

Re: qualify and unqualify

Wed, 16 Mar 2016 18:37:24 GMT

I got it while I was practicing.

UNQUALIFY * is needed at the end of load script, otherwise QUALIFY * is getting applied to script in next tabs as well

Re: qualify and unqualify

Wed, 07 Dec 2016 13:30:15 GMT

Hello!

Is ist possible to rename the unqualified OrderId? I tried it but it does not work!

QUALIFY *;

UNQUALIFY OrderID;

Orders:

LOAD OrderID AS TestOrderID, // this TestOrderID exists in another Table and should be a key

Order Name,

CustomerName,

FROM xxx.xls;

Thank you!

Re: qualify and unqualify

peterfarkas — Mon, 26 Nov 2018 17:22:31 GMT

If by "at the end of load script" you mean "end of each tab" then yes, because tabs don't technically split a script (just visually/logically).

Re: qualify and unqualify

Tool_Tip — Wed, 03 Sep 2025 06:49:25 GMT

Is it possible to given another random name while using qualify??

Orders.OrderID

Orders.OrderName

Orders.CustomerName

for example -
In above result set the fields are getting renamed with prefix as "Orders" because the table name is Orders.

If we want to quality all the fields from orders table but with another random name such as Temp, so expected result should be as witout changing table name from Orders to Temp?

Temp.OrderID

Temp.OrderName

Temp.CustomerName

Re: qualify and unqualify

Amit_Prajapati — Wed, 03 Sep 2025 08:54:02 GMT

Check the below Linkedin post for better understanding.

https://www.linkedin.com/posts/amit-prajapati-a52689217_understanding-qualify-and-unqualify-in-activity-7308089927781523456-ldxK?utm_source=share&utm_medium=member_desktop&rcm=ACoAADa9Qp4Bu5xRMXYr-SVz64cGSvt82DYZXEg

Re: qualify and unqualify

Tool_Tip — Wed, 03 Sep 2025 09:29:27 GMT

Dear Amit,

What's new in your post, in fact I found it is incomplete information about Qualify and Unqualify.
Kindly read the question again.

Re: qualify and unqualify

Amit_Prajapati — Wed, 03 Sep 2025 09:59:25 GMT

Shared post is about how Qualify function work.

bydefault it's takes the name of table as prefix.