Filter Pane: contains X or Y or Z

[nickmarlborough]

Hi 

I have a data set such as:

CITY

X , Y

X

K , Z

L , Z , X

X

Y , Z

How do i use a filter pane so that its a question of filter on any cell that contains either X or Y or Z

Thanks, 

Nick

[Or]

If X, Y, and Z might be part of a word, it sounds like you're looking for compound search combined with wildcards.

('*X*'|'*Y*'|'*Z*')

However, if X, Y, and Z are always full words, you could just use X Y Z as a search string.

I recommend this resource:

https://webapps.qlik.com/search-cheat-sheet/Qlik+Sense+Search+Cheat+Sheet+en-US.pdf