topic search substring in set analysis in QlikView https://community.qlik.com/t5/QlikView/search-substring-in-set-analysis/m-p/300002#M1198800 <HTML><HEAD></HEAD><BODY><P></P><H2>Hi it should work</H2><H3>sum( {$&lt;TASK_NAME= {" *mantis* "}&gt;} [ACTUAL] )</H3><BR /><BR /></BODY></HTML> Fri, 14 Jan 2011 11:47:37 GMT 2011-01-14T11:47:37Z search substring in set analysis https://community.qlik.com/t5/QlikView/search-substring-in-set-analysis/m-p/300000#M1198798 <HTML><HEAD></HEAD><BODY><P>hi everybody</P><P></P><P>i have this expression in a pivot table :</P><P></P><P>sum( {$ &lt; TASK_NAME="*mantis*") &gt;} [ACTUAL])</P><P></P><P>but i would have ACTUAL for all TASK with TASK_NAME contains substring mantis. How i can do that i try * <span class="lia-unicode-emoji" title=":confused_face:">😕</span></P></BODY></HTML> Fri, 14 Jan 2011 11:16:25 GMT https://community.qlik.com/t5/QlikView/search-substring-in-set-analysis/m-p/300000#M1198798 2011-01-14T11:16:25Z AW:search substring in set analysis https://community.qlik.com/t5/QlikView/search-substring-in-set-analysis/m-p/300001#M1198799 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P>your search mask should work fine. Did you copy/paste your expression? Then check for the ')' after your searchmask. Seems to be too much.</P><P>Hope thats it <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P><P>Roland</P></BODY></HTML> Fri, 14 Jan 2011 11:43:40 GMT https://community.qlik.com/t5/QlikView/search-substring-in-set-analysis/m-p/300001#M1198799 2011-01-14T11:43:40Z search substring in set analysis https://community.qlik.com/t5/QlikView/search-substring-in-set-analysis/m-p/300002#M1198800 <HTML><HEAD></HEAD><BODY><P></P><H2>Hi it should work</H2><H3>sum( {$&lt;TASK_NAME= {" *mantis* "}&gt;} [ACTUAL] )</H3><BR /><BR /></BODY></HTML> Fri, 14 Jan 2011 11:47:37 GMT https://community.qlik.com/t5/QlikView/search-substring-in-set-analysis/m-p/300002#M1198800 2011-01-14T11:47:37Z AW:Re: search substring in set analysis https://community.qlik.com/t5/QlikView/search-substring-in-set-analysis/m-p/300003#M1198801 <HTML><HEAD></HEAD><BODY><P>Hi Luca, you are right. The {} to include the searchmask are also missing!</P><P>RR</P></BODY></HTML> Fri, 14 Jan 2011 11:55:10 GMT https://community.qlik.com/t5/QlikView/search-substring-in-set-analysis/m-p/300003#M1198801 2011-01-14T11:55:10Z search substring in set analysis https://community.qlik.com/t5/QlikView/search-substring-in-set-analysis/m-p/300004#M1198802 <HTML><HEAD></HEAD><BODY><H3>thx for your answers<BR /></H3><H3>sum( {$&lt;TASK_NAME= {"*mantis*"}&gt;} [ACTUAL] ) make the job;) just a syntax error<BR /></H3><P></P><P></P></BODY></HTML> Fri, 14 Jan 2011 11:58:07 GMT https://community.qlik.com/t5/QlikView/search-substring-in-set-analysis/m-p/300004#M1198802 2011-01-14T11:58:07Z