Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
udaya_kumar
Specialist
Specialist

how to show only unselected values in listbox?

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?

5 Replies
Anonymous
Not applicable

Use calculated list box:

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

v_iyyappan
Specialist
Specialist

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
Specialist
Specialist
Author

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
Luminary Alumni
Luminary Alumni

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
Specialist
Specialist
Author

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