Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
sateeshkumar
Creator
Creator

show only possible values in list box

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.

1 Solution

Accepted Solutions
tresesco
MVP
MVP

May be a bit simpler, like:

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

View solution in original post

6 Replies
senpradip007
Specialist III
Specialist III

Check Hide Excluded option in general property.

tresesco
MVP
MVP

May be a bit simpler, like:

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

sateeshkumar
Creator
Creator
Author

Thank you.. It is working properly..

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

Not applicable

correct answer

Not applicable

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)

andydietler
Partner - Creator
Partner - Creator

I don't think you even need the only.

=Aggr(List2, List2)

works.