Dynamically Changing the colour of the dimension axis label

[#1]

I have two tables that show some values, for example

Table 1 - Stats           Table 2 - Current People

Name       Qty                   Name      Current

Mr Blog     50                   Mr Blog         1

Mrs Blog   10                   Ms Blog         1            

Ms Blog     25

I want the Graph to show the label text colour to Green if they are current and orange if they are not, for example

I used the Axis Font Colour to have the following formula:

IF(Sum (Current)>0, RGB(24,117,11),RGB(241,111,14))

But this only does the colour for the whole graph, not for each individual bar.

How do I make it work for each bar?

[Gabriel]

Hi Andre,

Can I ask, what version of QlikView you are using? Is it v10 or v11?

Regards,

Gabriel

[#3]

Good question, I should of stated sorry. I am using v10.

[Gabriel]

Hi Andre,

Go to Expression tab, click the + sign from the graph and to Backround colour then enter the fomula below. Please note I haven't test this formula.

IF($(current) =1,RGB(24,117,11),RGB(24,111,14))

[#5]

Thanks Gabriel,

Unfortunately it did not work Gabriel, the colour did not change at all

(to either options)

Andrew Sheward

[Gabriel]

Hi Andre,

I figure this out, even though I am using v11.

This is the expression for it:

=if(Current =1,RGB(24,117,11),RGB(241,111,14))

Also if you change the = to >0 it works perfectly well.

Let me know if this is helpful.

[#7]

Sorry Gabriel, my original question was to change the colour of the

label, not the colour of the bar itself, in my work I have a stacked bar

so I do not want to change the colour of the bar, I wanted to change the

colour of the label.

[Gabriel]

One more thing is to go to presentation, click on Legend Setting, Click on Font, click on Calculate and enter

=if(Current =1,RGB(24,117,11),RGB(241,111,14)).

Let me know if this is helpful

[#9]

Sorry Gabriel, I am trying to alter the label of the bar, not the

legend.

I have used the formula in the label font colour calculation but it does

not action the formula for each bar, it only does the colour of the

label as a whole

Andrew Sheward

[Gabriel]

Ok watch this clip and let me know

http://qlikshare.com/328