Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
mikevmalta
Partner - Contributor III
Partner - Contributor III

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
alexandros17
Partner - Champion III
Partner - Champion III

Select "Hide deleted"

View solution in original post

5 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Select "Hide deleted"

mikevmalta
Partner - Contributor III
Partner - Contributor III
Author

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!

alexandros17
Partner - Champion III
Partner - Champion III

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.

mikevmalta
Partner - Contributor III
Partner - Contributor III
Author

Thanks a lot for your replies

Not applicable

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.