Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
rhareesh
New Contributor II

How to filter list box values in chart

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

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: How to filter list box values in chart

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'

View solution in original post

5 Replies
Highlighted
rhareesh
New Contributor II

Re: How to filter list box values in chart

swuehl‌ could you pls help on this

Highlighted
rhareesh
New Contributor II

Re: How to filter list box values in chart

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

Highlighted

Re: How to filter list box values in chart

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

Highlighted
MVP
MVP

Re: How to filter list box values in chart

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'

View solution in original post

Highlighted
rhareesh
New Contributor II

Re: How to filter list box values in chart

thank you Stefan. It worked !