Filter Pane: contains X or Y or Z - Qlik Community

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: