https://community.qlik.com/t5/App-Development/If-statement-in-Script/m-p/1681448#M51846 <P>My field is CustomerType.&nbsp;</P><P>I want to transform the field so that if CustomerType IS NOT Equal to a value then name it something else.</P><P>I tried the following structure but am not receiving expected results. Am I using an incorrect operator?</P><P>IF(CustomerType &lt;&gt; 'Broker' or 'Reseller' or 'House' or 'Player' or 'Sponsor' or 'Employee', 'Personal',<BR />IF(CustomerType = 'Broker' or 'Reseller', 'Reseller')) AS CustomerTypeNew,</P><P>&nbsp;</P> Tue, 03 Mar 2020 18:23:13 GMT evansabres 2020-03-03T18:23:13Z https://community.qlik.com/t5/App-Development/If-statement-in-Script/m-p/1681448#M51846 <P>My field is CustomerType.&nbsp;</P><P>I want to transform the field so that if CustomerType IS NOT Equal to a value then name it something else.</P><P>I tried the following structure but am not receiving expected results. Am I using an incorrect operator?</P><P>IF(CustomerType &lt;&gt; 'Broker' or 'Reseller' or 'House' or 'Player' or 'Sponsor' or 'Employee', 'Personal',<BR />IF(CustomerType = 'Broker' or 'Reseller', 'Reseller')) AS CustomerTypeNew,</P><P>&nbsp;</P> Tue, 03 Mar 2020 18:23:13 GMT https://community.qlik.com/t5/App-Development/If-statement-in-Script/m-p/1681448#M51846 evansabres 2020-03-03T18:23:13Z https://community.qlik.com/t5/App-Development/If-statement-in-Script/m-p/1681458#M51850 <P>May be this</P><LI-CODE lang="markup">If(not Match(CustomerType, 'Broker', 'Reseller', 'House', 'Player', 'Sponsor', 'Employee'), 'Personal', If(Match(CustomerType, 'Broker', 'Reseller'), 'Reseller')) as CustomerTypeNew,</LI-CODE> Tue, 03 Mar 2020 19:05:56 GMT https://community.qlik.com/t5/App-Development/If-statement-in-Script/m-p/1681458#M51850 sunny_talwar 2020-03-03T19:05:56Z