Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
tka_ovako
Contributor II
Contributor II

Button that show and hide expression values under 100%

Hello.

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

Qlik100.JPG

BR.

Timo

5 Replies
tresesco
MVP
MVP

Could you share a sample qvw to work on?

Anonymous
Not applicable

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

tka_ovako
Contributor II
Contributor II
Author

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anonymous
Not applicable

Please see sample

Hope this will give you idea