Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

alex_almero
New Contributor

What does a color gray represents in a pie chart?

Being new to QlikSense I would like to understand what represents the gray color in a pie chart shown below. It does not have any label except '-' and cannot be selected as filter either.

2018-06-18_100217- gray section.png

Thanks

Alex

1 Solution

Accepted Solutions
jaumecf23
Contributor III

Re: What does a color gray represents in a pie chart?

This means the null values. I supose that you have some rows that the field Regions is not informed.

6 Replies
jaumecf23
Contributor III

Re: What does a color gray represents in a pie chart?

This means the null values. I supose that you have some rows that the field Regions is not informed.

JustinDallas
Valued Contributor

Re: What does a color gray represents in a pie chart?

I think in this instance, it means 'Null' because of the dash, but sometimes it can mean 'Others'.  Try clicking it and seeing what happens to your dimension.  Does every data point have a Region value?

alex_almero
New Contributor

Re: What does a color gray represents in a pie chart?

You could be right. It seems to be a 'Null' value but in my load script I have already set 'Null'values to 'Unknown' as already represented on the chart. So i'm unsure where could this value be coming from.

jschrader
New Contributor III

Re: What does a color gray represents in a pie chart?

I would suggest doing a if(len(trim(Region)) = 0, 1, 0) as field in load script on the field in question. Then, sum the field. This will tell you if you have any null values. I know there is also an ISNULL function, but it will not work if your field has space for a value. The trim will eliminate the spaces, giving you a true null count.

The chart means you do not have a value in the region category to display.

jschrader
New Contributor III

Re: What does a color gray represents in a pie chart?

You could also exclude null values in chart options.

alex_almero
New Contributor

Re: What does a color gray represents in a pie chart?

Having excluded the null values from the chart options cleared it. This values could have resulted from a 'join' where a record does not exist.  I will post a follow-up question handling null data from a 'join' if none exist.

Community Browser