topic Re: Expression to color Null Values on Pie/Donut Chart in QlikView

Expression to color Null Values on Pie/Donut Chart

ltc — Tue, 05 Jun 2018 20:00:41 GMT

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!

Re: Expression to color Null Values on Pie/Donut Chart

vishsaggi — Tue, 05 Jun 2018 21:38:08 GMT

Did you already wrote an expression in your script for your null values to Not Uploaded? If yes then may be just use like

IF(CCaR user DD2875 Is Valid = 'Not Uploaded', RGB()yourYelloColorvalue)

Re: Expression to color Null Values on Pie/Donut Chart

ltc — Tue, 05 Jun 2018 21:45:47 GMT

I'm not the owner of the app, so I don't have access to the data load editor/script. I was just going to add the expression here:

I tried your expression as follows, but it turned the whole donut grey.

IF([CCaR User DD2875 Is Valid] = 'Not Uploaded', RGB(255,255,0))

Re: Expression to color Null Values on Pie/Donut Chart

ltc — Tue, 05 Jun 2018 21:51:59 GMT

Re: Expression to color Null Values on Pie/Donut Chart

vishsaggi — Tue, 05 Jun 2018 22:07:39 GMT

Oh ok. I believe then it should be used this way. Could you able to share this app if possible?

Re: Expression to color Null Values on Pie/Donut Chart

ltc — Tue, 05 Jun 2018 22:13:47 GMT

I can't share it

Any other ideas?

Re: Expression to color Null Values on Pie/Donut Chart

ltc — Tue, 05 Jun 2018 22:16:42 GMT

I know what the problem is, but I don't know how to fix it.

I have the following expression under Data, Dimension:

=if(Len([CCaR User DD2875 Is Valid])=0,'Not Uploaded',[CCaR User DD2875 Is Valid])

This is what's causing the color expression to not work

Re: Expression to color Null Values on Pie/Donut Chart

ltc — Tue, 05 Jun 2018 22:19:03 GMT

Actually, that's not the problem. Because I am able to color the "No" portion of the donut with no problem

This expression does work:

IF([CCaR User DD2875 Is Valid] = 'No', RGB(255,255,0))

Re: Expression to color Null Values on Pie/Donut Chart

ltc — Tue, 05 Jun 2018 22:21:01 GMT

It's not coloring the "Not Uploaded" value maybe because it's a Null value

Re: Expression to color Null Values on Pie/Donut Chart

vishsaggi — Wed, 06 Jun 2018 04:24:01 GMT

Not sure, i will have to create some dummy data then play around with it and get back.

Re: Expression to color Null Values on Pie/Donut Chart

poojashribanger — Wed, 06 Jun 2018 04:46:45 GMT

may be you can use

if( isnull(expn),yellow)

Re: Expression to color Null Values on Pie/Donut Chart

poojashribanger — Wed, 06 Jun 2018 05:15:56 GMT

change your expression in dimension like

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

then colour by expression

it's working fine.