topic Re: Help with expression in QlikView https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/877726#M306489 <HTML><HEAD></HEAD><BODY><P><EM>LOAD Site, </EM></P><P><EM>&nbsp;&nbsp;&nbsp;&nbsp; if(wildmatch(Site,'EMEA*'), 'US', Region) as Region</EM></P><P><EM>FROM</EM></P><P><EM><SPAN>[</SPAN><A class="jive-link-thread-small" data-containerid="2051" data-containertype="14" data-objectid="168040" data-objecttype="1" href="https://community.qlik.com/thread/168040">https://community.qlik.com/thread/168040</A><SPAN>]</SPAN></EM></P><P><EM>(html, codepage is 1252, embedded labels, table is @1);</EM></P></BODY></HTML> Thu, 11 Jun 2015 20:26:58 GMT maxgro 2015-06-11T20:26:58Z Help with expression https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/877725#M306488 <HTML><HEAD></HEAD><BODY><P>I have a Table Site&nbsp; as </P><P></P><TABLE border="1" class="jiveBorder" height="159" style="border: 1px solid rgb(0, 0, 0); width: 798px; height: 82px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><P><STRONG><BR /></STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG>Site</STRONG></P></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Region</STRONG></TH></TR><TR><TD style="padding: 2px;">EMEA</TD><TD style="padding: 2px;">West</TD></TR><TR><TD style="padding: 2px;">EMEA-ND</TD><TD style="padding: 2px;">Midwest</TD></TR><TR><TD style="padding: 2px;">ND</TD><TD style="padding: 2px;">Asia</TD></TR><TR><TD style="padding: 2px;">abc</TD><TD style="padding: 2px;">Europe </TD></TR><TR><TD style="padding: 2px;">gfh</TD><TD style="padding: 2px;">China</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P>My requirement is where site ='EMEA' , it should be assigned to Region US. I tried following result but it doesnt work</P><P></P><P>load Site ,</P><P>if(Site='EMEA * ',Region='US',Region) as Region </P><P>resident Site;</P><P></P><P>please help</P></BODY></HTML> Thu, 11 Jun 2015 20:20:06 GMT https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/877725#M306488 arusanah 2015-06-11T20:20:06Z Re: Help with expression https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/877726#M306489 <HTML><HEAD></HEAD><BODY><P><EM>LOAD Site, </EM></P><P><EM>&nbsp;&nbsp;&nbsp;&nbsp; if(wildmatch(Site,'EMEA*'), 'US', Region) as Region</EM></P><P><EM>FROM</EM></P><P><EM><SPAN>[</SPAN><A class="jive-link-thread-small" data-containerid="2051" data-containertype="14" data-objectid="168040" data-objecttype="1" href="https://community.qlik.com/thread/168040">https://community.qlik.com/thread/168040</A><SPAN>]</SPAN></EM></P><P><EM>(html, codepage is 1252, embedded labels, table is @1);</EM></P></BODY></HTML> Thu, 11 Jun 2015 20:26:58 GMT https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/877726#M306489 maxgro 2015-06-11T20:26:58Z Re: Help with expression https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/877727#M306490 <HTML><HEAD></HEAD><BODY><P>Try with</P><P></P><P>if(left(site,4)='EMEA','US',Region) as Region</P></BODY></HTML> Thu, 11 Jun 2015 20:27:53 GMT https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/877727#M306490 stigchel 2015-06-11T20:27:53Z