Discussion Board for collaboration related to QlikView App Development.
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!
Select "Hide deleted"
View solution in original post
By any chance there isn't any way to avoid showing the grey area?
Sorry if I am asking too much (just curious)
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.
Thanks a lot for your replies
If you want to hide all the values which are not associated,
not to show gray values in the listbox
1. Go to the properties
2. On the General tab -> Field -> Expression
3. Give this expression over there =if(aggr(count(Field),Field),Field)
I welcome all your feedback.