Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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)