List box with alternate states..

[#1]

Hi everyone,

I have 3 list boxes with the same field such as i have product field list box three times having different alternate states to each 1 of them.

Product(1) list box have alternate state "one"

Product(2) list box have alternate state "two"

Product(3) list box have alternate state "three"

and for this i want to have a text box that shows:

Unique Product in Product(1),

Unique Product in Product(2),

Unique Product in Product(3),

Common Products in Product(1) and Product(2),

Common Products in Product(2) and Product(3),

Common Products in Product(1) and Product(3)

Please help.

Thanks in advance.

[simondachstr · Accepted solution]

Use set analysis in an =Concat expression.

For the unique textbox I would suggest using something like

=Concat({one-two-three) Product)

and for the common products:

=Concat({one*two} Product)

=Concat({two*three} Product) etc.

[#3]

Thanks a lot...It worked

[#4]

Hi,

Can you please help me with one more thing. In above question,

I want to add =if(getSelectedCount(Product)>0, "some condition")

So how can i add a particular alternate state for the field product in getSelectedCount?

and we want to put the condition that if Product(1) and Product(2) and Product(3) is not selected then it doesn't show the text box.

Please help.

Thanks.