Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

qualify and unqualify

please explain the qulify and unqualify

reddy

15 Replies
Not applicable
Author

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!

peterfarkas
Partner - Contributor
Partner - Contributor

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).
Tool_Tip
Creator III
Creator III

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

Amit_Prajapati
Creator II
Creator II

Tool_Tip
Creator III
Creator III

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.

Amit_Prajapati
Creator II
Creator II

Shared post is about how Qualify function work.

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