Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'd like to have the text within a text object change color based on different percentage ranges. I'm familiar with how to do simple 2 color changes based on the data but having trouble with 3 or more data ranges ... is there a way to use if statements to create font color changes based on the following example:
if data <99.7% make the text red ... or if data is between 99.7% and 99.8% make the text orange ... otherwise make the text green.
Yes, you can use your IF Statement in the Calculated base color
See an example below
Something like this... in calculated color...
if(SUM(QTY) < 400, GREEN(),
iF(SUM(QTY) < 600, RED(), QlikTechGray()))
Change SUM(QTY) to data and value to your %value and appropriate color....
Hope this will help
Tony
Have you considered ColorMix ?
Go to your Text Box Properties
Best Regards, Bill
Thanks All ... I'll give some of these a try to see if they'll work for me. I appreciate the replies!
Tony