topic Re: List Box Search Expression to exclude values in QlikView

List Box Search Expression to exclude values

Wed, 18 Jul 2012 08:45:40 GMT

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.

Re: List Box Search Expression to exclude values

swuehl — Wed, 18 Jul 2012 10:56:16 GMT

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

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

Re: List Box Search Expression to exclude values

Wed, 18 Jul 2012 11:26:50 GMT

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

Re: List Box Search Expression to exclude values

swuehl — Wed, 18 Jul 2012 13:33:13 GMT

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.

Re: List Box Search Expression to exclude values

Thu, 19 Jul 2012 09:47:39 GMT

I am using V11 and ajaz client.

Still, I cannot do an advnaced search

Re: List Box Search Expression to exclude values

swuehl — Thu, 19 Jul 2012 11:18:36 GMT

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%20Analysis.qvw&host=Demo11

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