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: 
rsdhavle
Creator III
Creator III

Selecting particular values from a field in a list box

Suppose there are 3 values A,B and C in one field which i am passing in the list box. I want to show only two values A and B and exclude the value 'C'. What is the approach to implement this? Set analysis? If yes what would be the expression?


1 Solution

Accepted Solutions
tresesco
MVP
MVP

List box -> Expression - > If( Match(FieldName, 'A', 'B') , FieldName)

View solution in original post

2 Replies
tresesco
MVP
MVP

List box -> Expression - > If( Match(FieldName, 'A', 'B') , FieldName)

sujeetsingh
Master III
Master III

See this sample