Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
aaronnayan
Creator III
Creator III

color coding in the pie chart

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

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

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())))

View solution in original post

5 Replies
ahaahaaha
Partner - Master
Partner - Master

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
MVP
MVP

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
Creator III
Creator III
Author

Hi Andrey,

no not there it is in the presentation tab.

It is in the text in the chart area

aaronnayan
Creator III
Creator III
Author

Hi Manisha that was spot on thankyou

MK_QSL
MVP
MVP

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