how to show only unselected values in listbox?

[udaya_kumar]

Hi,

i have one requirement that, i need to show only the unselected values in the listbox.

but i saw some of  the posts, they are telling to use  straight table.but there is one problem,

that i cannot select desired values from the table. but in listbox we can select any values (multiple values).

so how we can  do  this?

[Anonymous]

Use calculated list box:

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

[v_iyyappan]

Hi,

     Use the expression in listbox it show defaultly all amount but you select the any other fields it excluded the current selection amount for that particular selection

    =if(GetSelectedCount(Amount) >1,aggr(only({1-$} Amount),Amount),Amount)

Regards,

Iyyappan

[udaya_kumar]

hi, thanks for the help.. i have one listbox with market name and one listbox with products name. i wanted to apply this logic for product listbox. i applied this expression, its working fine only when am not selecting market, if i select market, then its showing all unselected and selected products in product listbox.

[jagan]

Hi Uday,

Can you come up with an example with some Products and Markets, it helps in understanding what you exactly wants.  If possible attach some sample document.

Regards,

Jagan.

[udaya_kumar]

Hi jagan, Actually i have three listbox,  one for market, one for product with all values including unselected and one more with unselected product listbox.

the expression mentioned above is working fine for products. if i select some value like 'Biologic' as market and some values in product like Humira, Enbrel. then the unselected product listbox showing all the values  selected and unselected products in that listbox. but i want only the unseleted values in that  listbox. product and market field are in same table in database.

if  i dont  select value in  market, then this expression works fine, showing only the  unselected  values in the listbox.

so how to  resolve this?

product values depends on the market