topic Re: Hiding a value on a bar chart in QlikView

Hiding a value on a bar chart

Wed, 19 Jun 2013 19:02:34 GMT

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!

Re: Hiding a value on a bar chart

shree909 — Wed, 19 Jun 2013 19:13:06 GMT

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

Re: Hiding a value on a bar chart

Wed, 19 Jun 2013 19:20:29 GMT

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

Re: Hiding a value on a bar chart

Anonymous — Wed, 19 Jun 2013 19:26:22 GMT

use this in calculated dimension

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

Re: Hiding a value on a bar chart

Wed, 19 Jun 2013 19:45:26 GMT

See attachment.

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

2. Show only first 2 dimensions

Re: Hiding a value on a bar chart

Wed, 19 Jun 2013 20:12:33 GMT

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.

Re: Hiding a value on a bar chart

Wed, 19 Jun 2013 20:16:51 GMT

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

Re: Hiding a value on a bar chart

Wed, 19 Jun 2013 20:30:39 GMT

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%

Re: Hiding a value on a bar chart

Wed, 19 Jun 2013 20:56:04 GMT

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

Re: Hiding a value on a bar chart

Wed, 19 Jun 2013 21:10:31 GMT

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.

Re: Hiding a value on a bar chart

paulyeo11 — Wed, 19 Jun 2013 23:26:14 GMT

Interesting post . May I know why you want to hide may be ?

Re: Hiding a value on a bar chart

Thu, 20 Jun 2013 02:50:00 GMT

Hi,

Please see attached.

Regards,

Janzen

Re: Hiding a value on a bar chart

Fri, 21 Jun 2013 19:02:59 GMT

The customer wants it this way. They didnt want their "maybe"s to be discounted in the numbers. The real values arent yes, no, maybe. There are many many more. NDA required that I change the data.

Re: Hiding a value on a bar chart

Fri, 21 Jun 2013 19:22:28 GMT

Janzen, so close... but I cant see every possibility.

This file is closer to what I am really trying to do.