2 Replies Latest reply: Nov 11, 2012 5:26 PM by bayraktar RSS

    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