Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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

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
tresesco
MVP
MVP

=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