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

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

Tue, 12 Nov 2013 21:52:43 GMT

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.

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

rustyfishbones — Tue, 12 Nov 2013 22:16:38 GMT

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

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

rustyfishbones — Tue, 12 Nov 2013 22:26:19 GMT

See an example below

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

MK_QSL — Tue, 12 Nov 2013 22:33:18 GMT

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?

Anonymous — Tue, 12 Nov 2013 22:38:06 GMT

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

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

Thu, 14 Nov 2013 20:29:59 GMT

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

Tony