Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
MVP
MVP

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

View solution in original post

2 Replies
swuehl
MVP
MVP

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
Author

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

Thank you very much.