topic Dimension Label Color in QlikView

Dimension Label Color

Tue, 07 Dec 2010 00:48:12 GMT

One of you might have stumbled on this. Changing the color of a dimension label is no problem when the chart is a pivot or straight table (see below). For a simple example I changed the FY dimension "Background Color" to red().

But when you change the chart type to anything but straight or pivot the dimension label changes back to default black (see second screen print below). I'd like my FY dimension label to be highlighted red like in my straight table below.

Any thoughts? Can this be done?

Much thanks

Dimension Label Color

pover — Tue, 07 Dec 2010 01:27:09 GMT

You can't do it directly, but try a workaround by creating a text object in the line or bar graph with a red background that you put around the dimension labels. Make sure to untick the option "On Top" so that the red background is under the dimension labels. The result of the workaround is below.

Regards.

Dimension Label Color

Tue, 07 Dec 2010 17:48:10 GMT

Ha Ha. That's clever Karl! Not the most elegant solution but hey it works. I would have never thought about doing this. Thank you very much for the post. I hope in future versions there is an option for doing this on graphical charts.

Dimension Label Color

Fri, 25 Mar 2011 17:14:21 GMT

Maybe more elegant is to add an expression with the Dimension Field as expression (=DimensionField).

Untick all Bar display checkboxes and Tick 'Text on Axis'. Also untick Expression as Legend. In the Background color expression of this expression change the color.

Finally untick the Dimension display legend box.

Dimension Label Color

Fri, 25 Mar 2011 18:34:53 GMT

Roeland great suggestion. It works! Simple and effective, the way I like it. Thanks man.

Re: Dimension Label Color

ljdlumley — Wed, 24 Sep 2014 14:11:54 GMT

Great solution, now how can I make that rotate 45 degrees as my labels overlap if they are horizontal.

Re: Dimension Label Color

anbu1984 — Wed, 24 Sep 2014 14:24:04 GMT

Chart Properties --> Axes --> Primary Dimension Labels - Select middle radio button for 45 degrees

Re: Dimension Label Color

ljdlumley — Wed, 24 Sep 2014 14:37:40 GMT

Anbu, that doesn't work in this case as we are using an expression label on the axes and not a Dimension label. Have a look at ranieuwe's answer to see what we were originally trying to solve.