Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mark_casselman
Creator
Creator

AND-Mode search problem

Hi,

We would like to offer our users the possibility to perform search capabilities on a list box. For normal list boxes this is easy, but we cannot seem to get it working on a list box in AND-Mode (see AND-Mode for a good article on AND-Mode).

See attached screenshot. What do I need to write in the search box to get the selection shown ?

We tried al sorts of combinations (e.g. '&Branch, ! Contactcenter'), none of them worked...

And-Mode search.jpg

The only search terms that works is typing 1 item (e.g. Branch) and it gets selected in AND Mode. Typing multiple items or trying to type a 'NOT item' does not seem to work.

Any AND-Mode specialists out there ?

Thanks,

Mark

3 Replies
richard_chilvers
Specialist
Specialist

Hi Mark

I haven't read your requirement in detail, but I do know that combining searches can be tricky (dare I say occasionally not possible?). You might want to read this short discussion before putting too much effort in.

Good luck !

Richard

http://community.qlik.com/thread/128696

mark_casselman
Creator
Creator
Author

Anybody to the rescue ?

mark_casselman
Creator
Creator
Author

Looking for a solution ?

We found a workaround solution ourselves. It doesn't seem possible to add a working search expression on an AND table, so we made a query on a normal table, including the P() and E() functions.

We included a button with:

- action 'select in field'

- field 'CustomerId'

- Search string : ='=count({<CustomerId=P({<Channel={'&chr(39)&'Branch'&chr(39)&'}>} CustomerId)>*<CustomerId=E({<Channel={'&chr(39)&'ContactCenter'&chr(39)&'}>} CustomerId)>}CustomerId)>0'

Using the formula count(Customer)>0 is just a trick to have a formula that selects all customers and that supports set expressions.

Mark