Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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!

13 Replies
shree909
Partner - Specialist II
Partner - Specialist II

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
Author

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

hidingqv2.png

Anonymous
Not applicable
Author

use this  in calculated dimension

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

Not applicable
Author

See attachment.

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

2. Show only first 2 dimensions

Not applicable
Author

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
Author

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
Author

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
Author

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

Not applicable
Author

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.