Discussion Board for collaboration related to QlikView App Development.
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
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())))
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
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())))
Hi Andrey,
no not there it is in the presentation tab.
It is in the text in the chart area
Hi Manisha that was spot on thankyou
Glad that it worked for you.. Would be more happy if you write my name correctly ... !!