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: 
Anonymous
Not applicable

Limit List box

Hi guys,

I would like to limit a list box to certain values a little like an IN statement in SQL.  Can this be done within an expression?

I have a list like this

Capture.JPG.jpg

Say i would like to see just Aprons and Bags in the list.

Can this be done?

thanks

Labels (1)
1 Solution

Accepted Solutions
ychaitanya
Creator III
Creator III

TRY

if(Match(Field,Aprons,'Bags'),Country,Null()) 

in the expression in the List Box Field Definiton

View solution in original post

4 Replies
tresB
Champion III
Champion III

=If(WildMatch(Type, '*Apron*', '*Bag*') ,Type)

PrashantSangle

Hi,

Write Expression in list Box

Like

If(Wlidmatch(Type,'Apron*','Bags*'),Type)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
ychaitanya
Creator III
Creator III

TRY

if(Match(Field,Aprons,'Bags'),Country,Null()) 

in the expression in the List Box Field Definiton

Anonymous
Not applicable
Author

Brilliant!

Thanks guys