Show non-selected Values

[#1]

Hi

Is it possible to show in a sparaded list box all values which are not selected in the other?

[swuehl]

Should be possible, maybe like

=aggr( only( {<FIELD = e()>} FIELD) ,FIELD)

[rbecher]

Hi Hansjörg,

you can use an expression like this:

=aggr(only({1-$} Field), Field)

- Ralf

[rbecher]

..this is not working

[swuehl]

Yes, it's working at my site ...

It is showing all values, that were possible before making the selection in FIELD, except the selected values.

Using 11.2 SR3 64 bit

[rbecher]

It works only on my site if no other field has a slection..

[swuehl]

No, I do get a result also with values selected in other fields.

But there is a difference between our two expressions, of course.

I've created a little example to show the difference.