What does a color gray represents in a pie chart?

[alex_almero]

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.

Thanks

Alex

[jaumecf23 · Accepted solution]

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

[JustinDallas]

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]

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]

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]

You could also exclude null values in chart options.

[alex_almero]

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.