Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
ltc
Partner - Creator
Partner - Creator

Expression to color Null Values on Pie/Donut Chart

Hi Qlik Community,

I have a donut chart with null values.  I have renamed the null values to "Not Uploaded" via an expression, as seen in the image below.  Now I need to color the "Not Uploaded" values yellow.  I want to use the standard Qlik Sense yellow from their color scheme "12 Colors".  See below.

What is the expression for this?

My field name is "CCaR User DD2875 Is Valid"

Thanks so much!

Donut.pngcolor yellow.png

11 Replies
poojashribanger
Creator II
Creator II

may be you can use

if( isnull(expn),yellow)

poojashribanger
Creator II
Creator II

change your expression in dimension like

if(isnull(dimension),'Not Uploaded',dimension)

then colour by expression

it's working fine.