multiple match function does not give right result

[#1]

I am quite new with Qlikview as developer. I have below question with match? I am glad if anybody could tell me what did I do wrong?

I got PIssueSIFIR calculated for item number which startes 2* .

  if(Match(tr_type,'ISS-SO') > 0 and match(tr_loc,'DP1074','dp1074') = 0 and match(tr_part,'2*') = 0 and tr_price = 0,if(tr_qty_chg <> 0, tr_qty_chg,tr_qty_loc),NULL()) AS PIssueSIFIR

KR

[swuehl · Accepted solution]

If you want to filter all tr_part that starts with a 2 by using

match(tr_part,'2*')

, i.e. the star symbol wildcard denotes a match 'regardless what comes after the 2', you need to use

wildmatch() function instead of match():

wildmatch(tr_part,'2*')

Hope this helps,

Stefan

[#3]

It helped Stefan. When I did with wildmatch, it worked.

Thank you very much.