topic Re: List box with alternate states.. in QlikView

List box with alternate states..

Tue, 08 Apr 2014 10:19:38 GMT

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 — Tue, 08 Apr 2014 10:22:59 GMT

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.

Tue, 08 Apr 2014 10:30:35 GMT

Thanks a lot...It worked

Tue, 08 Apr 2014 12:03:41 GMT

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.