topic Re: AND-Mode search problem in QlikView

AND-Mode search problem

mark_casselman — Wed, 01 Oct 2014 06:55:38 GMT

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...

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

Re: AND-Mode search problem

richard_chilvers — Wed, 01 Oct 2014 15:58:14 GMT

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

Re: AND-Mode search problem

mark_casselman — Mon, 20 Oct 2014 21:33:22 GMT

Anybody to the rescue ?

Re: AND-Mode search problem

mark_casselman — Wed, 29 Oct 2014 20:50:23 GMT

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