topic Color Coding Text Boxes in QlikView

Color Coding Text Boxes

Fri, 21 Mar 2014 07:21:35 GMT

I have 5 text boxes containing the revenue figures for each location and a text box containing the total revenue

I want to shade background of each of the 5 text boxes depending on their % of the total.

I can get the formulae to shade red and green depending on if the values are over or under 30% this formuale I have applied to the background formulae of Market St, Shudehill & Victoria. Market st and Victoria use the same basic two colour shading for +/-50% and works

BUT i want to shade the boxes in a gardient

I have tried to apply a formulae to the Shudehill background which looksup the percentage and takes the clour from a table but this doesnt work

In my final model i would like to use the gradual shading and have a different shade for each of the values !% to 100%

Any ideas please?

Re: Color Coding Text Boxes

MK_QSL — Fri, 21 Mar 2014 07:32:12 GMT

Like This?

Re: Color Coding Text Boxes

Fri, 21 Mar 2014 07:36:04 GMT

I have a licenced edition at work but I cant open your file at home.. could you key in the formulae

Re: Color Coding Text Boxes

MK_QSL — Fri, 21 Mar 2014 07:39:43 GMT

You can use calculated Base Color... like below..

ColorMix1(

(Sum({$<Stop={'MKT'}>}Revenue)/Sum(Revenue))/

Max(Total Aggr(Sum({$<Stop={'MKT'}>}Revenue)/Sum(Revenue), Stop)),

White(),

Green()

)

===============

Now Chagne MKT according to your field cell name... i.e. SHU, VIC,SPS, PIC etc...

I have taken WHITE() and GREEN() color for color gradient but obviously you can change as per your choice...

Re: Color Coding Text Boxes

Fri, 21 Mar 2014 10:48:13 GMT

Thats really helpful, nearly there i think. My fault this but in practice I didnt want the total value to be included. I wanted the darkest colour to be the highest value in the range of stops. So that the stop with the most revenue turned bright red. Could this be done?

Re: Re: Color Coding Text Boxes

rustyfishbones — Fri, 21 Mar 2014 11:08:12 GMT

Hi Glenn,

Is this what you require, it works, but I don't have time to explain it

Regards

Alan

Re: Re: Color Coding Text Boxes

rustyfishbones — Fri, 21 Mar 2014 11:15:22 GMT

Hi Glenn,

I will explain, did not realize you can't open the file

Step 1

Create a Variable called vColorIndex like below

Step 2 your text box Expression

Step 3 Your Background Color

Just change the Set Analysis for Stop for each Text Object

Hope that helps

Regards

Alan