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: 
ashokpaladugula
Contributor III
Contributor III

How to restrict the the listbox based on condition

Hi all,

I want restrict the listbox items based on condition. Im attaching the sample document.


jaganawhitfieldswuehladamdavi3scleveranjosmanojqlik

1 Solution

Accepted Solutions
tresesco
MVP
MVP

=If(not IsNull(Reason), customerName)

View solution in original post

7 Replies
tresesco
MVP
MVP

=If(not IsNull(Reason), customerName)

prma7799
Master III
Master III

Please try in your list box expression like below

=if( len (Reason) <>  0,customerName)

prma7799
Master III
Master III

PFA

Anil_Babu_Samineni

Or may be this too

=If(not WildMatch(Reason,0), customerName)

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
ashokpaladugula
Contributor III
Contributor III
Author

Thanks to all,

All above answers are correct and useful.

Thanks,

ASHOK

ashokpaladugula
Contributor III
Contributor III
Author

Hi Tresesco,

Listbox filter the values correctly, but in the current selections showing two filter values. so, i want show the selected customer filter in the current selection box. Please find the attachment.

customer filter issue.png

tresesco
MVP
MVP

Well, try the below expression:

=Aggr(only({<customerName,Reason={'*'}>} customerName), customerName)