Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

multiple match function does not give right result

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

1 Solution

Accepted Solutions
swuehl
Not applicable

Re: multiple match function does not give right result

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

2 Replies
swuehl
Not applicable

Re: multiple match function does not give right result

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

Not applicable

Re: multiple match function does not give right result

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

Thank you very much.