topic Re: Dynamically Changing the colour of the dimension axis label in QlikView

Dynamically Changing the colour of the dimension axis label

Tue, 28 Aug 2012 11:42:01 GMT

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?

Re: Dynamically Changing the colour of the dimension axis label

Gabriel — Tue, 28 Aug 2012 12:34:23 GMT

Hi Andre,

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

Regards,

Gabriel

Re: Dynamically Changing the colour of the dimension axis label

Tue, 28 Aug 2012 12:39:25 GMT

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

Re: Dynamically Changing the colour of the dimension axis label

Gabriel — Tue, 28 Aug 2012 12:45:32 GMT

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))

Re: Dynamically Changing the colour of the dimension axis label

Tue, 28 Aug 2012 13:00:16 GMT

Thanks Gabriel,

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

(to either options)

Andrew Sheward

Re: Dynamically Changing the colour of the dimension axis label

Gabriel — Tue, 28 Aug 2012 19:04:25 GMT

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.

Re: Dynamically Changing the colour of the dimension axis label

Wed, 29 Aug 2012 06:41:46 GMT

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.

Re: Dynamically Changing the colour of the dimension axis label

Gabriel — Wed, 29 Aug 2012 10:04:36 GMT

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

Re: Dynamically Changing the colour of the dimension axis label

Wed, 29 Aug 2012 10:12:00 GMT

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

Re: Dynamically Changing the colour of the dimension axis label

Gabriel — Wed, 29 Aug 2012 10:17:56 GMT

Ok watch this clip and let me know

http://qlikshare.com/328

Re: Dynamically Changing the colour of the dimension axis label

whiteline — Wed, 29 Aug 2012 11:19:45 GMT

I think the custom color expression for the font of the axis labels is calculated once.

Also, it likely neglects chart dimensions.

So, unfortunately, you have to use another tools to provide this info to user.

Re: Dynamically Changing the colour of the dimension axis label

Wed, 29 Aug 2012 13:06:38 GMT

Thankyou very much,

Andrew Sheward

Business Support Analyst,

Contact Strategy and Operational Analytics Development

Business Development Improvement and Risk

Retail Banking Operations

Business Services

Royal Bank of Scotland Group

4th Floor, Kendal Court, Telford, TF3 4DT

(Depot Code 034)

External Tel: +44 1952 206572

Internal Tel: 8171 6572

DATA CLASSIFICATION: unless otherwise stated the information contained

within this email is CONFIDENTIAL

Re: Dynamically Changing the colour of the dimension axis label

Tue, 16 Aug 2016 01:59:28 GMT

I have the solution, using Chart Properties:

1. In General menu, choose "Combo Chart"

2. In Dimensions menu, disable "Show legend"

3. In Expression menu, in addition to the expression Qty using the sum, you have to add another expression with the following definition: =only(name). Now, enable "Invisible" and disable in Display options "line" and enable "Text on axis".

Then, in "Text Color" you can put the definition: =if(current=1,RGB(24,117,11),RGB(241,111,14))

And now you have what you want.

Re: Dynamically Changing the colour of the dimension axis label

Anonymous — Tue, 11 Jul 2017 00:52:48 GMT

Answer is not relevant to the question

Re: Dynamically Changing the colour of the dimension axis label

Anonymous — Tue, 11 Jul 2017 00:57:36 GMT

I am looking the get Bold in the weened dates in a drill down dimension

Environment Bar chart, Groped staked

Dims

First dim is drill down as below

Month_year

Week

Date

Second dim is the grouped indicator to get the staked bar grouped

How do I get the Bold weekend dates in the X axis when value drill to the date level

Paul