Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
nicktodd
Creator
Creator

How to combine two wildcard searches?

I've got a document that queries a list of computers each of which have a name like

JFB999-B999-a9999

where 'a' can be 'W','E','A','S','E','X'

I want to find all 'E' or 'X' type computers, i.e. that match

JFB*-E*

or

JFB*-X*

and ideally have that search on a button that the users can click but I can't figure out how to combine the two wildcard searches.

Any ideas welcome!

Thanks

Nick

1 Solution

Accepted Solutions
Not applicable

Hi Nick

This one (a few years ago now) took my what seemed like a lifetime to work out, because I couldn't find any documentation of the syntax, but anyway, here's how you do it.

Add an action to the Button:

Select in Field, ComputerName then in the Search string put in: (JFB*-E*|JFB*-X*)

Hope it helps.

View solution in original post

4 Replies
Not applicable

Hi Nick

This one (a few years ago now) took my what seemed like a lifetime to work out, because I couldn't find any documentation of the syntax, but anyway, here's how you do it.

Add an action to the Button:

Select in Field, ComputerName then in the Search string put in: (JFB*-E*|JFB*-X*)

Hope it helps.

View solution in original post

jagan
MVP
MVP

Hi,

Is the format of all list of computers are same? 

Ex: JFB999-B999-a9999

Regards,

jagan.

nicktodd
Creator
Creator
Author

Brilliant - thanks! I was trying all ways....

nicktodd
Creator
Creator
Author

Jagan

No, not all - some have a completely different naming convention. Nigel has found a solution that seems to work.

Cheers

Nick