topic Re: start with in QlikView https://community.qlik.com/t5/QlikView/start-with/m-p/980857#M958911 <HTML><HEAD></HEAD><BODY><P>Try:</P><P>if(WildMatch(Country,'*can*'),'CA') as CA,</P></BODY></HTML> Wed, 28 Oct 2015 11:36:12 GMT robert_mika 2015-10-28T11:36:12Z start with https://community.qlik.com/t5/QlikView/start-with/m-p/980856#M958910 <HTML><HEAD></HEAD><BODY><P>hi all,</P><P></P><P>how can I write on script for start with</P><P></P><P>for ex</P><P></P><P>if column country start or contains can then 'CA'</P></BODY></HTML> Wed, 28 Oct 2015 11:32:50 GMT https://community.qlik.com/t5/QlikView/start-with/m-p/980856#M958910 raadwiptec 2015-10-28T11:32:50Z Re: start with https://community.qlik.com/t5/QlikView/start-with/m-p/980857#M958911 <HTML><HEAD></HEAD><BODY><P>Try:</P><P>if(WildMatch(Country,'*can*'),'CA') as CA,</P></BODY></HTML> Wed, 28 Oct 2015 11:36:12 GMT https://community.qlik.com/t5/QlikView/start-with/m-p/980857#M958911 robert_mika 2015-10-28T11:36:12Z Re: start with https://community.qlik.com/t5/QlikView/start-with/m-p/980858#M958912 <HTML><HEAD></HEAD><BODY><P>Try:</P><P>Load</P><P>--------------------</P><P>If(Left(Country,3) = 'can', 'CA', Country) as Country,</P><P>---------------------</P><P>---------------------</P></BODY></HTML> Wed, 28 Oct 2015 11:48:31 GMT https://community.qlik.com/t5/QlikView/start-with/m-p/980858#M958912 jsingh71 2015-10-28T11:48:31Z Re: start with https://community.qlik.com/t5/QlikView/start-with/m-p/980859#M958913 <HTML><HEAD></HEAD><BODY><P>create a field in script with below condition</P><P></P><P>if(wildmatch(lower(Country),'*can*','CA',<SPAN style="font-size: 13.3333330154419px;">Country) as Country</SPAN></P></BODY></HTML> Wed, 28 Oct 2015 11:52:21 GMT https://community.qlik.com/t5/QlikView/start-with/m-p/980859#M958913 Kushal_Chawda 2015-10-28T11:52:21Z