Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
NickHoff
Specialist
Specialist

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
sunny_talwar

May be this

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

View solution in original post

11 Replies
qv_testing
Specialist II
Specialist II

Use Wildmatch function...

Like

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

sunny_talwar

May be this

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

View solution in original post

Digvijay_Singh
Master III
Master III

I think you are suggesting wildmatch -

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

Chanty4u
Champion III
Champion III

instead try this ?

Goto the  Listbox Properties --> General

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

NickHoff
Specialist
Specialist
Author

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.

NickHoff
Specialist
Specialist
Author

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.

NickHoff
Specialist
Specialist
Author

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

sunny_talwar

swuehl
MVP
MVP

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

You need to enter the compound search exactly as shown.