18 Replies Latest reply: Jun 11, 2014 4:35 PM by Nancy Briceño Aguilar

# Exclude blanks in pie chart

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?

• ###### Re: Exclude blanks in pie chart

Hi,

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

and click on suppress null values.

Regards

ASHFAQ

• ###### Re: Exclude blanks in pie chart

Already tried this, but didn't work.

Thanks anyway

• ###### Re: Exclude blanks in pie chart

Hi,

Can you post your expression here.

Regards

ASHFAQ

• ###### Re: Exclude blanks in pie chart

Use set analysis in your expression like:

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

Hope this helps!

• ###### Re: Exclude blanks in pie chart

Hi,

What is "Set Analysis"?

• ###### Re: Exclude blanks in pie chart

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?

• ###### Re: Exclude blanks in pie chart

It's a simple count(KPI_1) which has three possible values: YES, NO, Blank.

I need only count(YES, NO)

Thanks

• ###### Re: Exclude blanks in pie chart

Try:

count({<KPI_1 = {'=len(trim(KPI_1))>0'}>}KPI_1)

Hope this helps!

• ###### Re: Exclude blanks in pie chart

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

• ###### Re: Exclude blanks in pie chart

Hi Jaime,

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

Please, can you help me more?

Thanks!

• ###### Re: Exclude blanks in pie chart

Hi, I put "value" as a field, because I didn't know what is your expression, just replace the word value with the name of the field you're using.

I guess that your expression is something like count(distinct KPI_1), am I right?

regards

• ###### Re: Exclude blanks in pie chart

Thanks Jaime,

I did it with:

count({<KPI_1 = {'=len(trim(KPI_1))>0'}>}KPI_1)

See you

• ###### Re: Exclude blanks in pie chart

Nancy,

Probablemente hay un nulo dado en su tabla. Tenemos que eliminar los datos de su dimensión. Hacer ver si los datos es nulo o no en su dimensión.

Saludos.

• ###### Re: Exclude blanks in pie chart

Muchas gracias Rogério, ya resolví el problema.

Saludos

Nancy

• ###### Re: Exclude blanks in pie chart

Hi Nancy,

=If(Not IsNull(Accomplishment),Accomplishment)

-JFlorian

• ###### Re: Exclude blanks in pie chart

In relation with

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