Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Exclude blanks in pie chart

Hi again,

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

pie.jpg

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

Tags (3)
1 Solution

Accepted Solutions
jerem1234
Valued Contributor II

Re: Exclude blanks in pie chart

Try:

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

Hope this helps!

18 Replies

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

jerem1234
Valued Contributor II

Re: Exclude blanks in pie chart

Use set analysis in your expression like:

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

Hope this helps!

jaimeaguilar
Valued Contributor II

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

Not applicable

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

Not applicable

Re: Exclude blanks in pie chart

Hi,

Chart Properties.jpg

Thanks

Not applicable

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!

Not applicable

Re: Exclude blanks in pie chart

Hi,

What is "Set Analysis"?

jerem1234
Valued Contributor II

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?

Community Browser