Button that show and hide expression values under 100%

[tka_ovako]

Hello.

I have line chart where is values under and over 100%. How I can make button that show only values under 100%? 

BR.

Timo

[tresesco]

Could you share a sample qvw to work on?

[Anonymous]

hide/ you mean the data point? or the whole series?

[tka_ovako]

Sorry about bad description. I need to make button or some kind of switch that filtering values in the whole series. So if the value is over 100% it will be ingnored. I also that same button do that vice versa so users can filtering those values out of the chart and also show those values if they want. I did variable but that  either show chart or hide whole chart.

=if(vSelectExcluded = 0, 1, 0)

Hope that is better description.

-Timo-

[Anil_Babu_Samineni]

You can make it this?

If(Variable=1 and Sum(Measure)<'100%', Sum(Measure))

OR

If(Variable=1 and Sum(Measure)/Sum(TOTAL <FIELDNAME> Measure)<'100%', Sum(Measure)/Sum(TOTAL <FIELDNAME> Measure))

Note - Instead of 100% you can use your own static number which returns in Percentage

[Anonymous]

Please see sample

Hope this will give you idea