topic Re: Exclude blanks in pie chart in QlikView

Exclude blanks in pie chart

Wed, 11 Jun 2014 16:44:44 GMT

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

Re: Exclude blanks in pie chart

ashfaq_haseeb — Wed, 11 Jun 2014 16:48:55 GMT

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

jerem1234 — Wed, 11 Jun 2014 16:49:06 GMT

Use set analysis in your expression like:

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

Hope this helps!

Re: Exclude blanks in pie chart

jaimeaguilar — Wed, 11 Jun 2014 16:52:48 GMT

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

Wed, 11 Jun 2014 16:56:40 GMT

Already tried this, but didn't work.

Thanks anyway

Re: Exclude blanks in pie chart

ashfaq_haseeb — Wed, 11 Jun 2014 17:05:10 GMT

Hi,

Can you post your expression here.

Regards

ASHFAQ

Re: Exclude blanks in pie chart

Wed, 11 Jun 2014 18:44:17 GMT

Hi,

Thanks

Re: Exclude blanks in pie chart

Wed, 11 Jun 2014 19:05:25 GMT

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

Wed, 11 Jun 2014 19:06:32 GMT

Hi,

What is "Set Analysis"?

Re: Exclude blanks in pie chart

jerem1234 — Wed, 11 Jun 2014 19:11:54 GMT

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

Wed, 11 Jun 2014 19:19:01 GMT

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

javier_florian — Wed, 11 Jun 2014 19:19:20 GMT

Hi Nancy,

Edit your group, and change your dimension to:

=If(Not IsNull(Accomplishment),Accomplishment)

-JFlorian

Re: Exclude blanks in pie chart

javier_florian — Wed, 11 Jun 2014 19:20:11 GMT

In relation with

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

Value is your metric KPI_1

-JFlorian

Re: Exclude blanks in pie chart

jerem1234 — Wed, 11 Jun 2014 19:20:18 GMT

Try:

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

Hope this helps!

Re: Exclude blanks in pie chart

jaimeaguilar — Wed, 11 Jun 2014 19:20:20 GMT

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

Wed, 11 Jun 2014 19:46:25 GMT

Thank you!!!

Re: Exclude blanks in pie chart

Wed, 11 Jun 2014 19:48:24 GMT

Thanks Jaime,

I did it with:

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

See you

Re: Exclude blanks in pie chart

rogerioqv — Wed, 11 Jun 2014 20:15:33 GMT

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

Wed, 11 Jun 2014 20:35:47 GMT

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

Saludos

Nancy