topic Re: Where Match Function not working in QlikView

Where Match Function not working

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Where Match Function not working

devarasu07 — Mon, 18 Sep 2017 15:42:25 GMT

HI,

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

also check this article

Using IN clause in QlikView – Learn QlikView

Re: Where Match Function not working

trdandamudi — Mon, 18 Sep 2017 15:42:39 GMT

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;

Re: Where Match Function not working

Anil_Babu_Samineni — Mon, 18 Sep 2017 15:43:10 GMT

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

Re: Where Match Function not working

vishsaggi — Mon, 18 Sep 2017 15:46:06 GMT

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

Re: Where Match Function not working

Colin-Albert — Mon, 18 Sep 2017 15:50:33 GMT

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/

Re: Where Match Function not working

shiveshsingh — Tue, 19 Sep 2017 01:40:57 GMT

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

Re: Where Match Function not working

Anonymous — Wed, 20 Sep 2017 05:50:00 GMT

Thanks verymuch its clear now