Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
It helped Stefan. When I did with wildmatch, it worked.
Thank you very much.