Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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