Exclude blanks in pie chart

[#1]

Hi again,

I have the following pie chart which includes values YES, NO and "blank".

I need that the chart takes only values Yes and No and it exclude the "blank" values.

How I can do that?

Thanks in advance

[ashfaq_haseeb]

Hi,

Right click on chart properties--> dimension tab --> Select your dimension

and click on suppress null values.

Regards

ASHFAQ

[jerem1234]

Use set analysis in your expression like:

{<Accomplishment = {'=len(trim(Accomplishment))>0'}>}

Hope this helps!

[jaimeaguilar]

Hi,

try one of these options in set analysis:

Count({$<Accomplishment-={''}>}value)

Count({$<Accomplishment-={'$(=chr(32))'}>}value) //space with ascii code

Count({$<Accomplishment-={'$(=chr(0))'}>}value) //blank character with ascii code

hope that helps

regards

[#5]

Already tried this, but didn't work.

Thanks anyway

[ashfaq_haseeb]

Hi,

Can you post your expression here.

Regards

ASHFAQ

[#7]

Hi,

Thanks

[#8]

Hi Jaime,

I tried all three alternatives and Qv does not recognize "value"

Please, can you help me more?

Thanks!

[#9]

Hi,

What is "Set Analysis"?

[jerem1234]

It can help reduce things in your sets of values for the expression you use, to put it simply.

What is the expression you are using in your chart?

On the tab called Expressions?