Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Cloud Maintenance is scheduled between March 27-30. Visit Qlik Cloud Status page for more details.
cancel
Showing results for 
Search instead for 
Did you mean: 
alex_almero
Contributor
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
Creator III
Creator III

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

View solution in original post

6 Replies
jaumecf23
Creator III
Creator III

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

JustinDallas
Specialist III
Specialist III

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
Contributor
Contributor
Author

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
Contributor III
Contributor III

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
Contributor III
Contributor III

You could also exclude null values in chart options.

alex_almero
Contributor
Contributor
Author

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.