QlikView Qualify

In Qlikview, we can rename the name of the existing fields for developing the relations among the data fields, and this process is called renaming fields. In QlikView, Data Fields are utilized as the main identifying factor for developing data associations. For Renaming the fields we use different methods like “Qualify” Statement, “Rename Field” Function. The QlikView Qualify Statement renames the data fields and delinks the links present between them. Through the given examples, you can understand how Field Renaming happens in Real-Time.

In this blog, we will discuss the following topics:

What are Renaming Fields? Renaming Fields using Qualify Statement Renaming Fields using AS Specifier Renaming Fields using Alias Statement Renaming Fields using Rename Field Function Conclusion

What are Renaming Fields?

Renaming Fields is a process of changing the names of the existing fields. Through renaming fields, we will link the data fields accurately. By Renaming Field names, we can delink the data fields. 

Want to Become an Expert in QlikView? Then visit here to Learn QlikView Training Online.

 

Renaming Fields using Qualify Statement

QlikView Qualify Statement is used for changing the provision of field names; field names will fetch the table name as an affix. 

Syntax:

Qualify *field_list

The automatic join between the fields is interrupted through the Qualify Statement. Qualify Statement Qualifies the data field name with its corresponding table. The names of the data fields are renamed, and the new names will be in the format “table name.newname”. 

table name is the same as the label of the current table. 

Related Article: Interval Match in Qlikview

We can understand the Qualify Statement in -detail through the following example:

We will create a table with the name “IT” 

ID	Course_Name	Price
1	Python	8,000
2	Java	11,000
3	.Net	13,000
4	Web Designing	10,000

 Now we will create another table and name it as “Non-IT” .

ID	Course_Name	Price
1	Autocad	12,000
2	VLSI	16,000
3	Embedded Systems	15,000
4	Digital Marketing	20,000

Now we will load the data into the Script

Qualify *;

IT:

LOAD[ID],

Course_Name,

Price

FROM

Qualify1.xlsx

(ooxml, embedded labels, table is IT);

Qualify *;

Non-IT:

LOAD[ID],

Course_Name,

Price

FROM

Qualify1.xlsx

(ooxml, embedded values, table is Non-IT)

Output:

IT.ID

1 2 3 4

 

IT.Price

8,000 11,000 13,000 10,000

Non-IT.Course_Name

Autocad VLSI Embedded Systems Digital Marketing

 

Non-IT.Price

12,000 16,000 15,000 20,000

Visit here to learn QlikView Training in Bangalore

 If we did not use the Qualify statement, QlikView will map both tables as follows:

ID

1 2 3 4

 

Course_Name

Python Java .Net Web Designing Autocad VLSI Embedded Systems Digital Marketing

 

Price

8,000 11,000 13,000 10,000 12,000 16,000 15,000 20,000

Merging of the tables worked for “ID” Field and for “Course_Name” and “Price” fields did not work.

We can solve this problem by Qualifying the fields that we don’t need to get associated with. 

Qualify Course_Name,

Price;

IT:

LOAD[ID],

Course_Name,

Price

FROM

Qualify1.xlsx;

(ooxml, embedded labels, table is IT);

Qualify Course_Name,

Price;

Non-IT:

LOAD[ID],

Course_Name,

Price

FROM

Qualify1.xlsx;

(ooxml, embedded labels, table is Non-IT);

Output:

ID

1 2 3 4

 

IT.Course_Name

Python Java .Net Web Designing

 

 

In the below screenshot, we can see how Qualify Statement is used in the QlikView Script:

Renaming Field Names using AS Specifier

The AS Specifier is used in the Load statement, and we can see it in the following query:

Load ID as CustomerID, Name, Address, Phone.no, State from Customer.csv;

In the above query, we used AS Specifier to rename the “ID” Field as “CustomerID”. 

In the below screenshot, we can see how AS Specifier is used to Rename the fields.

Rename Field Names using Alias Statement

We can rename the data fields using the Alias Statement, and Alias Statement Predates the LOAD Statement.

Example:

Alias ID as CustomerID;

Load * from Customer.csv;

In the above example, the data field from the data source “Customer.csv” with the name “ID” is renamed as “CustomerID”. This is used for creating the links with tables.

[Related Article: QlikView Metadata]

Renaming Fields using “Rename Field” Function

The Rename Field function is used to rename the fields.

Example:

Rename Field ID to CustomerID;

In the below screenshot, we can see how Rename Field function is used in the QlikView Script:

 

Explore QlikView Sample Resumes! Download & Edit, Get Noticed by Top Employers!

 

Conclusion

 There are many methods to rename the existing fields for building data associations. QlikView Qualify statement is a widely used method by the practitioners for renaming the fields. I hope this article provides you with the required information about Renaming the data fields. 

 If you have any queries, let us know by commenting in the below section.