topic Multiple Wild Card * * searches? in QlikView

Multiple Wild Card * * searches?

NickHoff — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have a user who wants to search a wildcard search field with multiple items.

We tried *item number1* | * item number2* | *item number3*, but had no luck.

as well as *item number1* & *item number2* & *item number3* with the same results.

It will work if we don't have the wild card search in there, but unfortunately they'll need it. Is this possible?

Re: Multiple Wild Card * * searches?

Nagaraju_KCS — Tue, 13 Mar 2018 19:07:25 GMT

Use Wildmatch function...

wildmatch (field name, '*itemnumbet*', *itemnumber2*')

Re: Multiple Wild Card * * searches?

sunny_talwar — Tue, 13 Mar 2018 19:09:10 GMT

May be this

("*item number1*"|"*item number2*"|"*item number3*")

Re: Multiple Wild Card * * searches?

Digvijay_Singh — Tue, 13 Mar 2018 19:09:35 GMT

I think you are suggesting wildmatch -

wildmatch( M, 'ja*','fe?','mar')

Re: Multiple Wild Card * * searches?

Chanty4u — Tue, 13 Mar 2018 19:11:20 GMT

instead try this ?

Goto the Listbox Properties --> General

You can try the "Use Wildcard Search" in Default Search Mode

Re: Multiple Wild Card * * searches?

NickHoff — Tue, 13 Mar 2018 19:15:11 GMT

I'm not looking for wildcard match. I'm referencing the object the user is searching on, i.e. they click a multi-box drop down and start typing to search for a field. They are using the wildcard search by adding * before and after the data they are searching for.

Re: Multiple Wild Card * * searches?

NickHoff — Tue, 13 Mar 2018 19:18:06 GMT

Yes, this is what i'm referring to, it will default the * before and after the search criteria. However, it's only allowing to search one item when the user needs to create a bookmark with hundreds.

Re: Multiple Wild Card * * searches?

NickHoff — Tue, 13 Mar 2018 19:21:13 GMT

I tried this and it didn't work as well.

Re: Multiple Wild Card * * searches?

sunny_talwar — Tue, 13 Mar 2018 19:23:36 GMT

Look here

Compound Search - demystified

Re: Multiple Wild Card * * searches?

swuehl — Tue, 13 Mar 2018 19:26:38 GMT

Sunny's search term using the compound search should work.

You need to enter the compound search exactly as shown.

Re: Multiple Wild Card * * searches?

NickHoff — Tue, 13 Mar 2018 19:39:40 GMT

I was missing the () around the search criteria that's what did it for me. Thank you Sunny!

Re: Multiple Wild Card * * searches?

MarcoWedel — Tue, 13 Mar 2018 23:32:40 GMT

using a search expression like

=WildMatch([field name], '*item number1*', '* item number2*', '*item number3*')

might very well be an alternative solution to your question, just make sure to start with an equals sign.

hope this helps

regards

Marco