Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Maybe I am missing a more simple search expression, but maybe like
=wildmatch(FIELD,'*A*') and not wildmatch(FIELD,'*B*','*C*)
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
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.
I am using V11 and ajaz client.
Still, I cannot do an advnaced search
Well, I can, here on my server and on the QV demo server, e.g.
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