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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Limit values in a list box

I have a list box that contains values for the type of results. The values are B,L, UA, W, TRF. I would like to exclude the value B and not allow it to be selected. Does this have to be done in an expression, and if so what would the formula look like?

Thank you for any help.

Labels (1)
3 Replies
Not applicable
Author

if(Value<>'B', Value)


Not applicable
Author

Perfect - and way too simple.

prabhu0505
Specialist
Specialist

very useful