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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Where Match Function not working

Hello Team,

I am new to Qlikview, can you help me on the below, where the where match function not working, is there any changes to be done in the script.

Directory;

LOAD Product_Id,

     Product_Line,

     Product_category,

     Product_Subcategory

FROM

[Match Function.csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

Where match(Product_Line, 'Food','Sporting Goods')

7 Replies
devarasu07
Master II
Master II

HI,

it's correct only, can you share your data. thanks

also check this article

Using IN clause in QlikView – Learn QlikView

trdandamudi
Master II
Master II

Can you provide sample data please... It will be helpful to understand and give you a solution. I do not see any issue on the code you pasted. Here is a quick example that will work:

Data:
Load * Inline [
Product_Id,Product_Line,Product_category,Product_Subcategory
100,Food,Cat1,SubCat11
200,Sporting Goods,Cat2,SubCat22
300,Balls,Cat3,SubCat33
]
;

NoConcatenate
Final:
LOAD Product_Id,
Product_Line,
Product_category,
Product_Subcategory
Resident Data
Where match(Product_Line, 'Food','Sporting Goods');

Drop Table Data;

Anil_Babu_Samineni

This condition should work, But Qlik is Case Sensitive. You have to initiate proper names in your Condiytion..

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
vishsaggi
Champion III
Champion III

how are your values in your Product_Line field? may be use Wildmatch().

Colin-Albert
Partner - Champion
Partner - Champion

There are several versions of the match function depending on whether you are doing a an exact match, a case insensitive match or a wildcard match.

Have a look at

match()

mixmatch()

wildmatch()

can any one explain mixmatch,wildmatch with example?

There is also a useful video on Qlikshare (search for Match) http://qlikshare.com/

shiveshsingh
Master
Master

Can you share data? it would be better if we check using your data and find the error..

Anonymous
Not applicable
Author

Thanks verymuch its clear now