topic Re: multiple match function does not give right result in QlikView

multiple match function does not give right result

Sun, 11 Nov 2012 21:04:49 GMT

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

Re: multiple match function does not give right result

swuehl — Sun, 11 Nov 2012 22:22:20 GMT

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

Re: multiple match function does not give right result

Sun, 11 Nov 2012 22:26:17 GMT

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

Thank you very much.