topic Re: Search String in button in QlikView https://community.qlik.com/t5/QlikView/Search-String-in-button/m-p/1189576#M384511 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Please post sample data.</P></BODY></HTML> Wed, 21 Sep 2016 13:08:27 GMT Anonymous 2016-09-21T13:08:27Z Search String in button https://community.qlik.com/t5/QlikView/Search-String-in-button/m-p/1189575#M384510 <HTML><HEAD></HEAD><BODY><P>Hi There</P><P></P><P>I have created a Button with an action that does a "Select in field"</P><P>My search string is as follows :&nbsp; (Car|Boat|Plane)</P><P>This works correctly to select those values in the "Categories" field.</P><P>How would I do a not function in this as to select all possible values except those 3 values.&nbsp;&nbsp; NOT (Car|Boat|Plane)</P><P></P><P>Your help is appreciated.</P></BODY></HTML> Wed, 21 Sep 2016 13:05:41 GMT https://community.qlik.com/t5/QlikView/Search-String-in-button/m-p/1189575#M384510 rido1421 2016-09-21T13:05:41Z Re: Search String in button https://community.qlik.com/t5/QlikView/Search-String-in-button/m-p/1189576#M384511 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Please post sample data.</P></BODY></HTML> Wed, 21 Sep 2016 13:08:27 GMT https://community.qlik.com/t5/QlikView/Search-String-in-button/m-p/1189576#M384511 Anonymous 2016-09-21T13:08:27Z Re: Search String in button https://community.qlik.com/t5/QlikView/Search-String-in-button/m-p/1189577#M384512 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">I think this should work: ( * ^ (Car|Boat|Plane))</SPAN></P><P>Perhaps this document helps: <A href="https://community.qlik.com/docs/DOC-15671">Compound Search - demystified</A></P></BODY></HTML> Wed, 21 Sep 2016 13:09:30 GMT https://community.qlik.com/t5/QlikView/Search-String-in-button/m-p/1189577#M384512 Gysbert_Wassenaar 2016-09-21T13:09:30Z Re: Search String in button https://community.qlik.com/t5/QlikView/Search-String-in-button/m-p/1189578#M384513 <HTML><HEAD></HEAD><BODY><P>I am not sure if this is possible directly</P><P>a Workaround would be:</P><P>1) define select in field Categories:&nbsp; (Car|Boat|Plane)</P><P>2) define Select excluded in field Categories </P></BODY></HTML> Wed, 21 Sep 2016 13:12:31 GMT https://community.qlik.com/t5/QlikView/Search-String-in-button/m-p/1189578#M384513 Anonymous 2016-09-21T13:12:31Z Re: Search String in button https://community.qlik.com/t5/QlikView/Search-String-in-button/m-p/1189579#M384514 <HTML><HEAD></HEAD><BODY><P>How about this:</P><P></P><P><STRONG>='(' &amp; Concat(DISTINCT {&lt;Categories = {'*'} - {'Car', 'Boat', 'Plane'}&gt;}Chr(34) &amp; Categories &amp; Chr(34), '|') &amp; ')'</STRONG></P></BODY></HTML> Wed, 21 Sep 2016 13:13:52 GMT https://community.qlik.com/t5/QlikView/Search-String-in-button/m-p/1189579#M384514 sunny_talwar 2016-09-21T13:13:52Z Re: Search String in button https://community.qlik.com/t5/QlikView/Search-String-in-button/m-p/1189580#M384515 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>please see this</P><P></P><P><A href="https://community.qlik.com/thread/74953">Expression in Search String via Action button</A></P><P></P><P>HTH</P><P></P><P>André Gomes</P></BODY></HTML> Wed, 21 Sep 2016 13:15:04 GMT https://community.qlik.com/t5/QlikView/Search-String-in-button/m-p/1189580#M384515 agomes1971 2016-09-21T13:15:04Z Re: Search String in button https://community.qlik.com/t5/QlikView/Search-String-in-button/m-p/1189581#M384516 <HTML><HEAD></HEAD><BODY><P>Thank You, This worked great</P></BODY></HTML> Thu, 22 Sep 2016 05:41:21 GMT https://community.qlik.com/t5/QlikView/Search-String-in-button/m-p/1189581#M384516 rido1421 2016-09-22T05:41:21Z