topic Re: Change Expression Label Colour in Bar Chart in QlikView

Change Expression Label Colour in Bar Chart

Anonymous — Thu, 05 Sep 2013 15:11:13 GMT

Hello everybody. How do I change the colour of the Expression Label in a Bar Chart? I can change tables using custom format but the Expression colour seems impossible to change in a bar chart. I can't find any setting where this can be changed. NB I can work around with titles in chart etc but this adds a complication as I am using the cyclic grouping and would need to change the title text depending on which expression I was looking at.

Any ideas?

Thanks in advance...

David

Re: Change Expression Label Colour in Bar Chart

Anonymous — Thu, 05 Sep 2013 19:52:02 GMT

David,

It's not quite clear what you mean by "expression label"... Apparently not the "title in chart", since you've mentioned it too. Is it the "legend"?

If it is - go to the Presentation tab, find Legend on top right, click "Settings". You'll find "Font" right there, and you can change the color. Even calculated, if you choose so.

If it's not the "legend", need clarification.

Regards,

Michael

Re: Change Expression Label Colour in Bar Chart

antose — Thu, 05 Sep 2013 20:56:02 GMT

Correct me if I have wrong but I think he means this. I have also investigate this earlier but not find any solutions for it.

Re: Change Expression Label Colour in Bar Chart

manas_bn — Thu, 05 Sep 2013 21:36:35 GMT

Isn't this the legend too? The expression label you give will be shown in the legend...

You can change the color/font/any setting for the legend in Presentation tab like Michael mentioned above...

Re: Change Expression Label Colour in Bar Chart

antose — Thu, 05 Sep 2013 22:01:05 GMT

Strange..

I see the Dimension name (month) and not the Expression. Anyway, its grayed out.

Re: Change Expression Label Colour in Bar Chart

Anonymous — Fri, 06 Sep 2013 08:02:07 GMT

Hi all, AnToSe is almost right in what my issue is - sorry if I didn't make my self clear. Each expression has a labal

and this label appears as a "title" in the chart. Since I am using a stacked bar the legend is not using this expression but a dimension. I have been able to change legend text colour - and all other text too.

I can't find anyway to change the text colour of the NUMBER. Clearly I would like it to be white like the other text.

Any more ideas?

Thanks in anticipation.

David

Re: Change Expression Label Colour in Bar Chart

michael_maeuser — Fri, 06 Sep 2013 08:05:13 GMT

if you don´t define a "title in chart" (tab general) it will take the name of your first expression. you can change th font in tab general "title settings"

Re: Change Expression Label Colour in Bar Chart

Anonymous — Fri, 06 Sep 2013 08:14:02 GMT

Yes that does enable the expression label to become the title and the font colour then changes to white - however that's a compromise I don't want to take. The cyclic button changes the applied expression and I'd like the expression label to change when it's clicked. If users can't cope with grey on black and I can't change it I may have to do this.

Re: Change Expression Label Colour in Bar Chart

michael_maeuser — Fri, 06 Sep 2013 08:22:23 GMT

i don´t understand the problem, you can either leave the title empty, so it takes the name of the expression you select in your cycle or can define a fix title

Re: Change Expression Label Colour in Bar Chart

Anonymous — Fri, 06 Sep 2013 08:27:14 GMT

My problem is that I want both. A fixed title for the chart and a changing subtitle (Expression label) below it. If it's not possible I will compromise one way or another but I'd like to know it's not possible rather than it being my lack of knowledge before I proceed.

Re: Change Expression Label Colour in Bar Chart

Anonymous — Fri, 06 Sep 2013 14:19:17 GMT

Agree with Michael above - there is no problem here. See this:

Window title is the same, as you type it. Expression is whatever is in cycle, and color defined by cycle settings.

Re: Change Expression Label Colour in Bar Chart

Anonymous — Mon, 09 Sep 2013 09:25:45 GMT

Hi all - I understand where I was going wrong now. I was getting in to the title settings and changing the colour to white. I didn't realise I should go deeper into the font in here and change colour again to white. All sorted now - thanks for all your help...

David

Re: Change Expression Label Colour in Bar Chart

er_mohit — Mon, 09 Sep 2013 09:33:08 GMT

for expression label BAck ground color change

go to presentation tab in properties of bar chart on top of right you 'll see the show legend check on it ,you see the setting button near of it go inside

and then you see the another pop up where you find the legend style background color of legeng and font also

hope it helps

Re: Change Expression Label Colour in Bar Chart

MariaLopez — Thu, 29 Oct 2020 12:31:39 GMT

Hi, David!

Could you tell me how you did, please?

I can' find the solution.

Thank you in advance.

María.