Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

flottmen
New Contributor

Nested Advanced Search

I am trying to write an expression that counts records from affiliates that have a minimum count.  This requires me to do a nested Advanced Search as follows:

Count({$<Affiliate|Channel={"=Count({$<DeliveryStatus={'D','O'}, LeadType-={'Leadborghini', 'Master Vendor'}, Affiliate-={"*Test*", "*Higher Ed*", "*Google*", "*AC Targeting*"}, Affiliate=, Channel=>}LeadId)>=250"}>} LeadId)

The Affiliate portion of the is giving me trouble because of the double quotes.  Is there a way to accomplish this?

1 Solution

Accepted Solutions
luismadriz
Valued Contributor

Re: Nested Advanced Search

Hi Eric,

Maybe this: [*Test*], [*Higher Ed*], [*Google*], [*AC Targeting*]

2 Replies
luismadriz
Valued Contributor

Re: Nested Advanced Search

Hi Eric,

Maybe this: [*Test*], [*Higher Ed*], [*Google*], [*AC Targeting*]

flottmen
New Contributor

Re: Nested Advanced Search

Totally worked.  Thank you.

Community Browser