How to restrict the the listbox based on condition

[ashokpaladugula]

Hi all,

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

jagan‌awhitfield‌swuehl‌adamdavi3s‌cleveranjos‌manojqlik‌

[tresB · Accepted solution]

=If(not IsNull(Reason), customerName)

[prma7799]

Please try in your list box expression like below

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

[prma7799]

PFA

[Anil_Babu_Samineni]

Or may be this too

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

[ashokpaladugula]

Thanks to all,

All above answers are correct and useful.

Thanks,

ASHOK

[ashokpaladugula]

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.

[tresB]

Well, try the below expression:

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