Listbox limit possible selections based on another field

[Anonymous]

I'd like to be able to limit the available selections in a listbox based on a selection made on another specific chart. Using the function P (possible) doesn't work because as soon as a single selection is made in the listbox - the other possibilities go away. Sorting by frequency is also not as useful (even with show alternatives) as the list is very long. I'm not sure how I'd use set analysis for this - are there any suggestions?

I've attached a sample qvw to hopefully illustrate what I would like

[maxgro]

maybe

=aggr(only({<City= P({<City=>}City)>}City),City)

[krishna_2644]

using maxgro‌ expression,i have enabled conditional view on list boxes.

check the attached.

[evan_kurowski · Accepted solution]

Hello Cary, give this a try

=Aggr(Only({$ <F1>} F1),F1)

The Only( {$}) part will have the listbox only show possible values

The <F1> part will not reduce the shown list by any selections in that field

[Anonymous]

Thanks all - while both options gave me the solution - Evan's was simpler in calculation time