List Box Search Expression to exclude values

[#1]

I am trying to do a search (wildsearch) in a list box. I could find the expression to search A or B as (*A*|*B*) but I am unable to find a similar expression which performs the following search

Include A but not B and Not C

Please help me on how to perform the above search action.

[swuehl]

Maybe I am missing a more simple search expression, but maybe like

=wildmatch(FIELD,'*A*') and not wildmatch(FIELD,'*B*','*C*)

[#3]

Thanks Swuehl but if I am not wrong, the advanced search option doesnt work in the web version of Qlikview. I have the applicated hosted on a server and is being used using Internet Explorer

[swuehl]

Which version are you using? Are you using AJAX or plugin client?

AFAIK, it should work starting from V10, but I also encountered problems from time to time with the Ajax client.

[#5]

I am using V11 and ajaz client.

Still, I cannot do an advnaced search

[swuehl]

Well, I can, here on my server and on the QV demo server, e.g.

http://eu.demo.qlik.com/QvAJAXZfc/opendoc.htm?document=qvdocs/Sales%20Management%20and%20Customer%20...

I think you need to take care that you are not using the associative search, but the standard search when inputting the advanced search expression.

In above demo, try inputting

=wildmatch(ProductCategoryName,'*B*')

in the search bar of the Product Category list box (standard search, not associative search).

This should select only 'Bikes'.

Hope this helps,

Stefan