Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
amithmurali
Partner - Creator II
Partner - Creator II

Show few values in Selection box.

Hi guys,

I need to filter some values in a selection box. i need to show only a few values for selection.

for eg, i have the values from A to Z in the field Alphabets, I want to show only these in the Selection box " A,E,I,O,U".

I tried to use the following the expressions but its not working.

if(Alphabets = { 'A','E','I','O','U'}, Alphabets)

if(Alphabets = ( 'A'&'E'&'I'&'O'&'U'), Alphabets)

1 Solution

Accepted Solutions
arulsettu
Master III
Master III

try this

if(match(fieldname,'A','E','I','O','U'),fieldname)

View solution in original post

1 Reply
arulsettu
Master III
Master III

try this

if(match(fieldname,'A','E','I','O','U'),fieldname)