How to filter list box values in chart

[Anonymous]

Hi ,

I have a chart as below :

A,B and C are the KPI's in which A is in Blue Color , B is in Yellow Color and C is in Red colour. I have a list box where there are Person names in that. When i click on any person name :

1)I should get only A and B i.e Blue and Yellow colors and not red color(I am able to accomplish this by using getselectedcount(person)=0 in the conditional statement of the C kpi )

2)When i click on "NLL" value in Person list box i must get only C value i.e only red colour .

Am unable to get the 2nd condition mentioned above. Is it possible to filter for the values in the same list box multiple times ?

Pls let me know how to achieve this.

Thanks

[Anonymous]

swuehl‌ could you pls help on this

[Anonymous]

stalwar1‌ could you pls help out with the above query I have

[sunny_talwar]

Is there a qvw file you can share where we can see the set up you have?

[swuehl · Accepted solution]

Maybe add a second condition to the red expression conditional:

=getselectedcount(person)=0 or Only(person) = 'NLL'

and also add conditional to the expression for blue and yellow:

=Only(person) <> 'NLL'

[Anonymous]

thank you Stefan. It worked !