topic Button that show and hide expression values under 100% in QlikView

Button that show and hide expression values under 100%

tka_ovako — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Button that show and hide expression values under 100%

tresB — Tue, 08 May 2018 06:22:50 GMT

Could you share a sample qvw to work on?

Re: Button that show and hide expression values under 100%

Anonymous — Tue, 08 May 2018 06:33:48 GMT

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

Re: Button that show and hide expression values under 100%

tka_ovako — Tue, 08 May 2018 09:49:25 GMT

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-

Re: Button that show and hide expression values under 100%

Anil_Babu_Samineni — Tue, 08 May 2018 11:23:07 GMT

You can make it this?

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

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

Re: Button that show and hide expression values under 100%

Anonymous — Wed, 09 May 2018 13:43:58 GMT

Please see sample

Hope this will give you idea