Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
ashokpaladugula
New 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
MVP
MVP

Re: How to restrict the the listbox based on condition

=If(not IsNull(Reason), customerName)

View solution in original post

7 Replies
MVP
MVP

Re: How to restrict the the listbox based on condition

=If(not IsNull(Reason), customerName)

View solution in original post

prma7799
Honored Contributor III

Re: How to restrict the the listbox based on condition

Please try in your list box expression like below

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

prma7799
Honored Contributor III

Re: How to restrict the the listbox based on condition

PFA

Re: How to restrict the the listbox based on condition

Or may be this too

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

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
New Contributor III

Re: How to restrict the the listbox based on condition

Thanks to all,

All above answers are correct and useful.

Thanks,

ASHOK

ashokpaladugula
New Contributor III

Re: How to restrict the the listbox based on condition

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

MVP
MVP

Re: How to restrict the the listbox based on condition

Well, try the below expression:

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