https://community.qlik.com/t5/App-Development/Convert-if-to-PickMatch/m-p/1630788#M46972 <P>What about something like this?</P><P>Pick(Match(Field1&amp;'|'&amp;Field2, 'Valuex1|Valuey1',&nbsp; 'Valuex1|Valuey2' ,&nbsp; 'Valuex1|Valuey3', 'Valuex2|Valuey1', etc...), Exp11, Exp12, Exp13, Exp21, etc...)</P><P>&nbsp;</P> Wed, 02 Oct 2019 22:04:11 GMT Vegar 2019-10-02T22:04:11Z https://community.qlik.com/t5/App-Development/Convert-if-to-PickMatch/m-p/1630774#M46971 <P>Hi everyone!</P><P>One question, i have the following if:</P><P>if(Field1=Valuex1,</P><P>&nbsp; &nbsp; &nbsp; if(Field2=Valuey1, Expression,</P><P>&nbsp; &nbsp; &nbsp; if(Field2=Valuey2,Expression,</P><P>&nbsp; &nbsp; &nbsp; if(Field2=Valuey3,Expression,</P><P>if(Field1=Valuex2,</P><P>&nbsp; &nbsp; &nbsp; if(Field2=Valuey1, Expression,</P><P>&nbsp; &nbsp; &nbsp; if(Field2=Valuey2,Expression,</P><P>&nbsp; &nbsp; &nbsp; if(Field2=Valuey3,Expression</P><P>))))))))</P><P>I want to use pick match instead of that big if (it is even bigger)</P><P>Any ideas?</P><P>Thanks in advance</P><P>&nbsp;</P> Sat, 16 Nov 2024 04:29:34 GMT https://community.qlik.com/t5/App-Development/Convert-if-to-PickMatch/m-p/1630774#M46971 vmoreno2605 2024-11-16T04:29:34Z https://community.qlik.com/t5/App-Development/Convert-if-to-PickMatch/m-p/1630788#M46972 <P>What about something like this?</P><P>Pick(Match(Field1&amp;'|'&amp;Field2, 'Valuex1|Valuey1',&nbsp; 'Valuex1|Valuey2' ,&nbsp; 'Valuex1|Valuey3', 'Valuex2|Valuey1', etc...), Exp11, Exp12, Exp13, Exp21, etc...)</P><P>&nbsp;</P> Wed, 02 Oct 2019 22:04:11 GMT https://community.qlik.com/t5/App-Development/Convert-if-to-PickMatch/m-p/1630788#M46972 Vegar 2019-10-02T22:04:11Z