Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

How to have multi-color changes to text object text?

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.

5 Replies
rustyfishbones
Honored Contributor II

Re: How to have multi-color changes to text object text?

Yes, you can use your IF Statement in the Calculated base color

2013-11-12_2204.png

rustyfishbones
Honored Contributor II

Re: How to have multi-color changes to text object text?

See an example below

2013-11-12_2214.png

Re: How to have multi-color changes to text object text?

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

Re: How to have multi-color changes to text object text?

Tony

Have you considered ColorMix ?

Go to your Text Box Properties

  • General
  • Click Background | Colour
  • Click Base Colour | Calculated
  • Edit Expression
  • File | ColorMix Wizard
  • Follow the prompts

Best Regards,     Bill

Not applicable

Re: How to have multi-color changes to text object text?

Thanks All ... I'll give some of these a try to see if they'll work for me. I appreciate the replies!

Tony

Community Browser