topic Re: How to filter list box values in chart in QlikView

How to filter list box values in chart

Anonymous — Tue, 10 Jul 2018 12:38:40 GMT

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

Re: How to filter list box values in chart

Anonymous — Wed, 11 Jul 2018 05:41:44 GMT

swuehl‌ could you pls help on this

Re: How to filter list box values in chart

Anonymous — Wed, 11 Jul 2018 12:45:47 GMT

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

Re: How to filter list box values in chart

sunny_talwar — Wed, 11 Jul 2018 12:47:50 GMT

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

Re: How to filter list box values in chart

swuehl — Fri, 13 Jul 2018 09:36:33 GMT

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'

Re: How to filter list box values in chart

Anonymous — Wed, 29 Aug 2018 06:27:56 GMT

thank you Stefan. It worked !