topic color coding in the pie chart in QlikView

color coding in the pie chart

aaronnayan — Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys i am in need of you help

So guys i need to color code the font in my chart so when the number is a certain value it would change color for example

0-50 red

51-70 yellow

71+ green

I have made the font for the chart in "text in chart" which is in the presentation tab.

I have also created 3 variables that have the certain values set

vmin

vmid

vhigh

i appreciate anyone's help as this is a tough one to crack

many thanks guys

ahaahaaha — Wed, 05 Apr 2017 09:11:16 GMT

Hi Aaron,

Can there be a formula for the color you entered not on the desired tab? Look at the attached file, please.

Regards,

Andrey

MK_QSL — Wed, 05 Apr 2017 09:14:18 GMT

Do you want to change color of Font in TEXT IN CHART ?

Use something as below for Calculated Color expression

=IF(SUM(Value)>=0 and SUM(Value) <= 50, RED(),

IF(SUM(Value)>=51 and SUM(Value) <= 70, YELLOW(),

Green())))

aaronnayan — Wed, 05 Apr 2017 09:48:33 GMT

Hi Andrey,

no not there it is in the presentation tab.

It is in the text in the chart area

aaronnayan — Wed, 05 Apr 2017 09:50:41 GMT

Hi Manisha that was spot on thankyou

MK_QSL — Wed, 05 Apr 2017 09:52:52 GMT

Glad that it worked for you.. Would be more happy if you write my name correctly ... !!