Hiding a value on a bar chart

[#1]

See chart below:

I need to hide the "Maybe"s and Still have Yes/No populate with 45%.

I have also attached my sample QV document.

I imagine I can do this in the Expression tab? But Im not sure what syntax to use.

Thank you in advance for any input!

[shree909]

Hi try this in the dimesion field

=

if(match(Response,'No' ,'Yes'),Response)

this will show only yes, no and check mark  Suppress when value is null

[#3]

That solves the hiding of the bar, but makes the values 50% and 50%

[Anonymous]

use this  in calculated dimension

= if (response <>'Maybe',response)

[#5]

See attachment.

1. Change expression to =TextCount(Response) / TextCount(TOTAL Response)

2. Show only first 2 dimensions

[#6]

So close!!!

Sometimes there are more "Maybes" than "Yes" or "No". So your solution to show only first two dimentions shows this in that scenario:

Also there are about 15+ values in the real dashboard Im trying to implement and they fluxuate.

[#7]

OK, then:

=TextCount(if(Match(Response, 'Yes', 'No', 'List here oher options you wish to appear'), Response)) / TextCount(TOTAL Response)

and you can uncheck the Dimension Limitation

[#8]

The other options I want to list are variable and come from the database on reload.

I did try this...

=TextCount(if(Response <>'Maybe',Response)) / TextCount(TOTAL Response)

But I still Get 50% and 50% not 45% and 45%

[#9]

My QlikView version (latest) shows OK the attachment 45% and 45%

[#10]

Looks good, But the difference is that I have two expressions. I need the percent and the count(left hand bar need to be a count).

i.e 45% and 9 for Yes/No

the count is displayed on the left side, in your example there is a percent on the left side.

When I try to create/modify the second expression the "Maybe" shows back up.