Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

qvelhoff
Valued Contributor

Multiple Wild Card * * searches?

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?

1 Solution

Accepted Solutions

Re: Multiple Wild Card * * searches?

May be this

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

11 Replies
qv_testing
Valued Contributor

Re: Multiple Wild Card * * searches?

Use Wildmatch function...

Like

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

Re: Multiple Wild Card * * searches?

May be this

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

Digvijay_Singh
Honored Contributor III

Re: Multiple Wild Card * * searches?

I think you are suggesting wildmatch -

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

sureshqv
Esteemed Contributor III

Re: Multiple Wild Card * * searches?

instead try this ?

Goto the  Listbox Properties --> General

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

qvelhoff
Valued Contributor

Re: Multiple Wild Card * * searches?

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.

qvelhoff
Valued Contributor

Re: Multiple Wild Card * * searches?

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.

qvelhoff
Valued Contributor

Re: Multiple Wild Card * * searches?

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

Re: Multiple Wild Card * * searches?

MVP
MVP

Re: Multiple Wild Card * * searches?

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

You need to enter the compound search exactly as shown.

Community Browser