topic Restrict Listbox values in QlikView

Restrict Listbox values

mikevmalta — Fri, 03 May 2013 15:28:24 GMT

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

alexandros17 — Fri, 03 May 2013 15:29:22 GMT

Select "Hide deleted"

mikevmalta — Fri, 03 May 2013 15:33:40 GMT

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 — Fri, 03 May 2013 15:38:54 GMT

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 — Fri, 03 May 2013 15:41:32 GMT

Thanks a lot for your replies

Thu, 08 Aug 2013 12:12:38 GMT

Hi,

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

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.