Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Restrict Listbox values

Hi,

I am loading a field in a listbox with an expression, so that only those values for which certain amount of days have passed will appear.

However when I am selecting more than one value from this listbox, I am getting all the possible values (greyed out) being shown.

Can this be avoided? i.e. I don't want the other values, that the expression does not satisfy, appearing in grey.

Thanks in advance!


Michael

1 Solution

Accepted Solutions
Highlighted

Re: Restrict Listbox values

Select "Hide deleted"

View solution in original post

5 Replies
Highlighted

Re: Restrict Listbox values

Select "Hide deleted"

View solution in original post

Highlighted
Partner
Partner

Re: Restrict Listbox values

Thanks alexandros17!

By any chance there isn't any way to avoid showing the grey area?

Sorry if I am asking too much (just curious)

Thanks!

Highlighted

Re: Restrict Listbox values

I think you can't,

if you have preselected values and you want to show only some values you can do

if(myfield='myvalue', myfield, null())

this filter values but when you make a selection the old problem appears again because other values keep existing.

Highlighted
Partner
Partner

Re: Restrict Listbox values

Thanks a lot for your replies

Highlighted
Not applicable

Re: Restrict Listbox values

Hi,

If you want to hide all the values which are not associated,

or

not to show gray values in the listbox

Try this,

1. Go to the properties

2. On the General tab -> Field -> Expression

3. Give this expression over there       =if(aggr(count(Field),Field),Field)

Done.

I welcome all your feedback.