Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read 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.