topic Re: if condition for mutiple values in field in QlikView https://community.qlik.com/t5/QlikView/if-condition-for-mutiple-values-in-field/m-p/1361281#M837967 <HTML><HEAD></HEAD><BODY><P>working .. thank you</P></BODY></HTML> Wed, 17 May 2017 12:22:21 GMT stonecold111 2017-05-17T12:22:21Z if condition for mutiple values in field https://community.qlik.com/t5/QlikView/if-condition-for-mutiple-values-in-field/m-p/1361277#M837963 <HTML><HEAD></HEAD><BODY><P>if(field1='colr code','freq data' and field2='group', 'pqr',abc')</P><P></P><P>how to write this in qlikview </P><P>i want multiple selections for the first field i mean field1</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/if-condition-for-mutiple-values-in-field/m-p/1361277#M837963 stonecold111 2020-11-25T16:16:04Z Re: if condition for mutiple values in field https://community.qlik.com/t5/QlikView/if-condition-for-mutiple-values-in-field/m-p/1361278#M837964 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P><STRONG>if(Match(field1, 'colr code','freq data') and Match(field2, 'group', 'pqr',abc'), 'Yes', 'No')</STRONG></P></BODY></HTML> Wed, 17 May 2017 11:48:59 GMT https://community.qlik.com/t5/QlikView/if-condition-for-mutiple-values-in-field/m-p/1361278#M837964 Anil_Babu_Samineni 2017-05-17T11:48:59Z Re: if condition for mutiple values in field https://community.qlik.com/t5/QlikView/if-condition-for-mutiple-values-in-field/m-p/1361279#M837965 <HTML><HEAD></HEAD><BODY><P>Hello, Suresh!</P><P></P><P>Try to use "or": =if((field1='val1' or <SPAN style="font-size: 13.3333px;">field1='val2'</SPAN> or <SPAN style="font-size: 13.3333px;">field1='val3') and field2='val1','A','B')</SPAN></P></BODY></HTML> Wed, 17 May 2017 11:51:25 GMT https://community.qlik.com/t5/QlikView/if-condition-for-mutiple-values-in-field/m-p/1361279#M837965 Sergey_Shuklin 2017-05-17T11:51:25Z Re: if condition for mutiple values in field https://community.qlik.com/t5/QlikView/if-condition-for-mutiple-values-in-field/m-p/1361280#M837966 <HTML><HEAD></HEAD><BODY><P>not working . i dont know why</P></BODY></HTML> Wed, 17 May 2017 12:21:30 GMT https://community.qlik.com/t5/QlikView/if-condition-for-mutiple-values-in-field/m-p/1361280#M837966 stonecold111 2017-05-17T12:21:30Z Re: if condition for mutiple values in field https://community.qlik.com/t5/QlikView/if-condition-for-mutiple-values-in-field/m-p/1361281#M837967 <HTML><HEAD></HEAD><BODY><P>working .. thank you</P></BODY></HTML> Wed, 17 May 2017 12:22:21 GMT https://community.qlik.com/t5/QlikView/if-condition-for-mutiple-values-in-field/m-p/1361281#M837967 stonecold111 2017-05-17T12:22:21Z Re: if condition for mutiple values in field https://community.qlik.com/t5/QlikView/if-condition-for-mutiple-values-in-field/m-p/1361282#M837968 <HTML><HEAD></HEAD><BODY><P>May be you need condition as either this or that. That is the case it should work</P></BODY></HTML> Wed, 17 May 2017 12:27:53 GMT https://community.qlik.com/t5/QlikView/if-condition-for-mutiple-values-in-field/m-p/1361282#M837968 Anil_Babu_Samineni 2017-05-17T12:27:53Z Re: if condition for mutiple values in field https://community.qlik.com/t5/QlikView/if-condition-for-mutiple-values-in-field/m-p/1361283#M837969 <HTML><HEAD></HEAD><BODY><P>if it matches means it returns 1 or 2 or 3 </P><P>so i think i you need to give if(match(.....)&gt;0</P><P>am i right??</P></BODY></HTML> Wed, 17 May 2017 12:38:07 GMT https://community.qlik.com/t5/QlikView/if-condition-for-mutiple-values-in-field/m-p/1361283#M837969 stonecold111 2017-05-17T12:38:07Z