Filter in a List box

[#1]

Hi,

I am busy with Comparative analysis and I created 2 groups which consists out of Resort Names.  These Resorts are both Local and International resorts.  I only want the user to be able to see the Local resorts in each List box.  There is a Local/International indicator on my Resort table which indicates if a Resort is Local or International.  Where and how would I use this indicator to filter out only the Local resorts to show in the 2 List boxes?

[Anonymous]

The easiest and most natural way is to create an additional list box with "Local/International" field.  Select 'Local' - and your Resort list will show only local.

Another approach is to create calculated list boxes separately for local and international Resorts.

[#3]

Yes,  I've tried the first option, but it doesn't work.  I guess it is because I am busy with Comparative analysis and I had to create the groups with an alternate state.

Please tell me more about the calculated list boxes?

Thanks

[Anonymous · Accepted solution]

If a simple solution doesn't work - what can you expect from a more complex?  If you use alternate states, make sure that you new "Local/International" list box is in the same state as the "Resorts" list box.

Calculated list box, since you've asked...  For the list of Local Resorts, it will be using expression

aggr(only({<[Local/International]={Local}> } Resort), Resort)

Similar for International.

(Assuming I guessed right the field name and values...)

[#5]

Thanks Michael,

I made sure the Local/International List box is in the same state as the Resort List box and now it is working.

Thanks for your help.