list box with field with Expression

[Anonymous]

Hello, I am trying that a "list box" that contains 10 offices, only load 2 of them  this way:

= only({<OFFICE={'NY','LA'}>} OFFICE)

but it doesn't work.

I know I can do this with a condition "if" but I want to use the fuction instead.

Have any one of you used this function ? Can you put some example of the right syntaxis for using it ?

Tks for you help.

[#2]

Hello,

i'm not sure what you want. Try this:

=only({$<OFFICE*={'NY','LA'}>}OFFICE)

Function:

If you select 'NY' or 'LA'  it will be displayed and it doesn't matter if any other of the 8 offices are selected.

If you select none or both of this two offices nothing will be displayed.

P.S. This functions works only in diagram.

[#3]

This Expression will not work ...may be because 'Only' func returns only one Value.