topic Color Chart table column titles in different colors in QlikView

Color Chart table column titles in different colors

Tue, 12 Apr 2011 09:43:17 GMT

Hi guys,

I have a chart object formatted as table.

The table has one dimension column and four expressions.

I need to set the TITLE of the first TWO EXPRESSION columns in one color (let's say blue) and the last TWO EXPRESSION columns in a different color (let's say red).

How can I achieve that?

Thanks in advance,

Aldo.

Color Chart table column titles in different colors

Tue, 12 Apr 2011 09:53:31 GMT

Hello,

Try this: Goto Properties, Click on the expression then expand the + sign under that, there you see the Background Colour and text formatting...etc. So if you want to use green colour to the first 2 expressions, just type GREEN() and that is fine. same thing with other expressions, try and use Red()... Its just around this.

Hope that helps,
ANDY

Color Chart table column titles in different colors

Tue, 12 Apr 2011 10:03:26 GMT

I tried that, but it doesn't afect Column TITLE..

Color Chart table column titles in different colors

Tue, 12 Apr 2011 10:06:15 GMT

Hello,

If you are trying something in the PIVOT chart and the column title is a dimension, then thats how it works,... QV doesnt support full color formatting of column labels and sometimes the whole column itself...Maybe you can check some sample QVWs(tutorials).

Color Chart table column titles in different colors

vgutkovsky — Tue, 12 Apr 2011 18:12:04 GMT

Aldo,

First, turn on the design grid (View --> Design Grid). Hold down CTRT+SHIFT, right-click on your object, and select "Custom Format Cell." You can then select your title/header cell and define a custom color.

Regards,

Color Chart table column titles in different colors

Oleg_Troyansky — Wed, 13 Apr 2011 02:30:45 GMT

I don't think that individual Expression labels can be formatted/colored separately. If I remember correctly, all the Headings are supposed to be the same font size, format and color. I might be wrong though, but I haven't seen how to do it yet...

Color Chart table column titles in different colors

Wed, 13 Apr 2011 04:15:32 GMT

With Custom Format cell, you change the color of the label of all columns. I need to set two different colors.

I tried using a calculated expression to define the background color under Custom Format Cell, but it doesn't work.

Finally, I separated my table into two different tables...

Aldo.

Color Chart table column titles in different colors

Oleg_Troyansky — Wed, 13 Apr 2011 04:34:17 GMT

That's probably the only way...

Color Chart table column titles in different colors

vgutkovsky — Wed, 13 Apr 2011 07:15:26 GMT

Did you try using rowno()=0 in the background color expression to check for the header row? I'm not sure if that will work, but it's worth a shot.

Regards,