Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
maybe
=aggr(only({<City= P({<City=>}City)>}City),City)
using maxgro expression,i have enabled conditional view on list boxes.
check the attached.
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
Thanks all - while both options gave me the solution - Evan's was simpler in calculation time