topic Re: Pick - match with 2 columns in QlikView https://community.qlik.com/t5/QlikView/Pick-match-with-2-columns/m-p/1374294#M799399 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Pick(WildMatch(Dim1&amp;'|'&amp;Dim2, 'A|*', '*|B') + 1, 0, 1, 1) as Test</STRONG></P><P></P><P>So, the above will assign 1 when Dim1 = 'A' or Dim2 = 'B', for rest other the Test = 0</P></BODY></HTML> Fri, 08 Dec 2017 14:29:09 GMT sunny_talwar 2017-12-08T14:29:09Z Pick - match with 2 columns https://community.qlik.com/t5/QlikView/Pick-match-with-2-columns/m-p/1374293#M799398 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P>is there any way to compare 2 columns with pick - match function for below expression for ex</P><P>if(Dim1='A' or Dim2= 'B','X') as Test</P><P></P><P></P><P>-Priya</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Pick-match-with-2-columns/m-p/1374293#M799398 priyarane 2020-11-25T16:16:04Z Re: Pick - match with 2 columns https://community.qlik.com/t5/QlikView/Pick-match-with-2-columns/m-p/1374294#M799399 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Pick(WildMatch(Dim1&amp;'|'&amp;Dim2, 'A|*', '*|B') + 1, 0, 1, 1) as Test</STRONG></P><P></P><P>So, the above will assign 1 when Dim1 = 'A' or Dim2 = 'B', for rest other the Test = 0</P></BODY></HTML> Fri, 08 Dec 2017 14:29:09 GMT https://community.qlik.com/t5/QlikView/Pick-match-with-2-columns/m-p/1374294#M799399 sunny_talwar 2017-12-08T14:29:09Z