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: 
Not applicable

show excluded values in alternate list box

Hi Friends,

I have a scenario ,

     list box contactname is with alternate state group1 when i made selections excluded order id should shown in another list box with alternate state group2.

3 Replies
NickHoff
Specialist
Specialist

Use an expression for the listbox like:

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


or change ContactName ot Order_ID

Not applicable
Author

its not working ,

logic is)

1)select a contactname,

2)Orderid is field contains related and excluded ,i want excluded values as new list box,

3)Contactname group1 alternate state, and orderid is group2 alternate state

NickHoff
Specialist
Specialist

Okay, that is because they are alternate states, instead of the $ in the excluded orderID's replace that with your alternate state name, and change

=aggr(only({1-AlternateStateName}OrderID),ContactName)