topic Re: show only possible values in list box in QlikView

show only possible values in list box

sateeshkumar — Tue, 07 Oct 2014 07:06:22 GMT

I have a requirement that to show only possible values in list box based on selection of other list box.

for example:

List1,List2 are two fields.

on selecting any value in ListA, I need to show only possible(white background) Values.

I tried like this

=aggr(only({$<List2 = P(List2 )>}List2 ),List2 )

It is working but on any selecting list2, it is showing green values. I need to show green values along with grey values also.

Can any one help me to get this?

Thank you.

Re: show only possible values in list box

senpradip007 — Tue, 07 Oct 2014 07:09:09 GMT

Check Hide Excluded option in general property.

Re: show only possible values in list box

tresB — Tue, 07 Oct 2014 07:14:18 GMT

May be a bit simpler, like:

=Aggr(Only({<List2>} List2), List2)

Re: show only possible values in list box

sateeshkumar — Wed, 08 Oct 2014 05:27:28 GMT

Thank you.. It is working properly..

But can you please explain its functionality(How it works).

Re: show only possible values in list box

Thu, 23 Jun 2016 20:36:16 GMT

correct answer

Re: show only possible values in list box

Sun, 22 Jan 2017 14:47:50 GMT

How should i add an alternate state to the expression above?

I want the 'study_level' alternate field to work for the the listbox site_num. I applied the following expression to the site listbox but it did not work.

=aggr(only({study_level <site_num= P(site_num)>}site_num),site_num)

Re: show only possible values in list box

andydietler — Fri, 21 May 2021 17:17:31 GMT

I don't think you even need the only.

=Aggr(List2, List2)

works.