Show Excluded Values

[#1]

Hi everyone,

Can I create a list box or other object that lists all excluded values in a dimension?

I want to create a functionality where the user selects a [Company], and a list box shows all related [Orders]. Then, when he selects some orders, the other excluded orders will appear in a second list box. Ideally, the user would then be able to add some of the excluded orders back into the selection, and have the list update.

Any guesses? Thanks.

[awhitfield]

HI Andrew,

can you post an example app?

Andy

[richard_chilvers]

Hi Andrew

You could have a second list box with the following expression; it seems to work but is not very elegant !

=

IF(NOT GetFieldSelections(Orders)=Orders,Orders)

[#4]

Sure Andy, although not sure if it will be helpful.

In this app, I have selected Company 'A'. I then have Contracts 'v' and 'w' available to select.

If I select 'v', I would like contract 'w' (the excluded value within set Company='A), to be listed separately somewhere.

Ideally in addition, the user could then select 'w' again to have it returned to the selection.

Best,

Andrew !

[giakoum]

see attached

[maxgro · Accepted solution]

try with this expression in listbox

=aggr(Only({$ <Order=E(Order)>} Order), Order)

[#7]

Awesome, awesome, thank you all! All your responses were correct, but I gave the correct answer to Massimo, because his solution very cleverly only shows those selections excluded within Company 'A'.

Thanks!