topic Nested Advanced Search in App Development https://community.qlik.com/t5/App-Development/Nested-Advanced-Search/m-p/1407266#M32941 <HTML><HEAD></HEAD><BODY><P>I am trying to write an expression that counts records from affiliates that have a minimum count.&nbsp; This requires me to do a nested Advanced Search as follows:</P><P></P><P>Count({$&lt;Affiliate|Channel={"=Count({$&lt;DeliveryStatus={'D','O'}, LeadType-={'Leadborghini', 'Master Vendor'}, Affiliate-={"*Test*", "*Higher Ed*", "*Google*", "*AC Targeting*"}, Affiliate=, Channel=&gt;}LeadId)&gt;=250"}&gt;} LeadId)</P><P></P><P>The Affiliate portion of the is giving me trouble because of the double quotes.&nbsp; Is there a way to accomplish this?</P></BODY></HTML> Thu, 14 Dec 2017 22:41:02 GMT flottmen 2017-12-14T22:41:02Z Nested Advanced Search https://community.qlik.com/t5/App-Development/Nested-Advanced-Search/m-p/1407266#M32941 <HTML><HEAD></HEAD><BODY><P>I am trying to write an expression that counts records from affiliates that have a minimum count.&nbsp; This requires me to do a nested Advanced Search as follows:</P><P></P><P>Count({$&lt;Affiliate|Channel={"=Count({$&lt;DeliveryStatus={'D','O'}, LeadType-={'Leadborghini', 'Master Vendor'}, Affiliate-={"*Test*", "*Higher Ed*", "*Google*", "*AC Targeting*"}, Affiliate=, Channel=&gt;}LeadId)&gt;=250"}&gt;} LeadId)</P><P></P><P>The Affiliate portion of the is giving me trouble because of the double quotes.&nbsp; Is there a way to accomplish this?</P></BODY></HTML> Thu, 14 Dec 2017 22:41:02 GMT https://community.qlik.com/t5/App-Development/Nested-Advanced-Search/m-p/1407266#M32941 flottmen 2017-12-14T22:41:02Z Re: Nested Advanced Search https://community.qlik.com/t5/App-Development/Nested-Advanced-Search/m-p/1407267#M32942 <HTML><HEAD></HEAD><BODY><P>Hi Eric,</P><P></P><P>Maybe this: [*Test*], [*Higher Ed*], [*Google*], [*AC Targeting*]</P></BODY></HTML> Thu, 14 Dec 2017 23:06:04 GMT https://community.qlik.com/t5/App-Development/Nested-Advanced-Search/m-p/1407267#M32942 luismadriz 2017-12-14T23:06:04Z Re: Nested Advanced Search https://community.qlik.com/t5/App-Development/Nested-Advanced-Search/m-p/1407268#M32943 <HTML><HEAD></HEAD><BODY><P>Totally worked.&nbsp; Thank you.</P></BODY></HTML> Fri, 15 Dec 2017 18:01:23 GMT https://community.qlik.com/t5/App-Development/Nested-Advanced-Search/m-p/1407268#M32943 flottmen 2017-12-15T18:01:23Z