topic Re: search in set analysis in QlikView https://community.qlik.com/t5/QlikView/search-in-set-analysis/m-p/607974#M224476 <HTML><HEAD></HEAD><BODY><P>It works! Thanks a lot!!! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 23 Apr 2014 07:13:31 GMT 2014-04-23T07:13:31Z search in set analysis https://community.qlik.com/t5/QlikView/search-in-set-analysis/m-p/607971#M224473 <HTML><HEAD></HEAD><BODY><P>Good day!</P><P></P><P>Please help to search text value in set analysis.</P><P>For example, I need to find all managers in field <SPAN style="color: #800000; font-size: 8pt;">[CR_L3_Code]</SPAN> which contains 'Kvs' and join them tothe general name 'Kiev' in the dimension .</P><P>It seems to be easy, using the '*', but formula like this doesn't work:</P><P><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[CR_L3_Code]</SPAN><SPAN style="font-size: 8pt;">='*Kvs*', 'Kiev', 'no')&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 227px;"><TBODY><TR><TD class="xl66" height="45" width="108">CR_L3_Code</TD><TD class="xl67" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="119">=<BR />&nbsp; if([CR_L3_Code]='*Kvs*','Kiev','no') </TD></TR><TR><TD class="xl65" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">UM-Kvs-C-TT-1</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">no</TD></TR><TR><TD class="xl65" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">UM-Dnp-S-TT</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">no</TD></TR><TR><TD class="xl65" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">UM-Dnt-C-AL-2</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">no</TD></TR><TR><TD class="xl65" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">UM-Kvs-D-AL</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">no</TD></TR><TR><TD class="xl65" height="17" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">UM-Dnt-S-OT</TD><TD class="xl65" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">no</TD></TR></TBODY></TABLE><P></P><P>What can be wrong?</P><P></P><P>Thanks in advance!</P></BODY></HTML> Wed, 23 Apr 2014 07:04:45 GMT https://community.qlik.com/t5/QlikView/search-in-set-analysis/m-p/607971#M224473 2014-04-23T07:04:45Z Re: search in set analysis https://community.qlik.com/t5/QlikView/search-in-set-analysis/m-p/607972#M224474 <HTML><HEAD></HEAD><BODY><P>Try using WildMatch()</P></BODY></HTML> Wed, 23 Apr 2014 07:08:53 GMT https://community.qlik.com/t5/QlikView/search-in-set-analysis/m-p/607972#M224474 tresB 2014-04-23T07:08:53Z Re: search in set analysis https://community.qlik.com/t5/QlikView/search-in-set-analysis/m-p/607973#M224475 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Try<BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">If(WildMatch([CR_L3_Code], '*Kvs*'),'Kiev', 'no')</SPAN></P></BODY></HTML> Wed, 23 Apr 2014 07:12:16 GMT https://community.qlik.com/t5/QlikView/search-in-set-analysis/m-p/607973#M224475 CELAMBARASAN 2014-04-23T07:12:16Z Re: search in set analysis https://community.qlik.com/t5/QlikView/search-in-set-analysis/m-p/607974#M224476 <HTML><HEAD></HEAD><BODY><P>It works! Thanks a lot!!! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 23 Apr 2014 07:13:31 GMT https://community.qlik.com/t5/QlikView/search-in-set-analysis/m-p/607974#M224476 2014-04-23T07:13:31Z