Where Match Function not working

[Anonymous]

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')

[devarasu07]

HI,

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

also check this article

Using IN clause in QlikView – Learn QlikView

[trdandamudi]

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..

[vishsaggi]

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

[Colin-Albert]

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]

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

[Anonymous]

Thanks verymuch its clear now