Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Hiding a value on a bar chart

See chart below:

hidingqv.png

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!

Tags (3)
13 Replies
shree909
Valued Contributor II

Re: Hiding a value on a bar chart

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

Not applicable

Re: Hiding a value on a bar chart

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

hidingqv2.png

srikanthsri1
Valued Contributor

Re: Hiding a value on a bar chart

use this  in calculated dimension

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

Not applicable

Re: Hiding a value on a bar chart

See attachment.

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

2. Show only first 2 dimensions

Not applicable

Re: Hiding a value on a bar chart

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:

hidingqv3.png

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

Not applicable

Re: Hiding a value on a bar chart

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

Not applicable

Re: Hiding a value on a bar chart

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%

Not applicable

Re: Hiding a value on a bar chart

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

Not applicable

Re: Hiding a value on a bar chart

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.

hidingqv.png

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

Community Browser