topic Red numbers in chart in QlikView

Red numbers in chart

Thu, 11 Jun 2009 14:14:32 GMT

Hello,

I have a combo chart with line.

I want to paint the color of the numbers in line with red if the numbers less then 0.

I write in "Text color" section the line: "=if(((Column(2)/Column(1))-1)<0,rgb(255,0,0))"

The color of the number not changed.

I'll be happy to hear any recommendation haw to solve this issue.

Elad

Red numbers in chart

amars — Thu, 11 Jun 2009 17:58:30 GMT

Hi,

I am not sure , if I understand your question correctly, but for conditional formating you can go in Properties -> Visual cues in uppe or lower try to use a formula for conitional formating and if the condition in the box is true then the color in front of the textbox is applied for the text.

Regards,

Amar

Red numbers in chart

Thu, 11 Jun 2009 18:03:44 GMT

Amar

Visual cues will property will applicable to only PIVOT and STRAIGHT table not on Charts. But he wants to do in Combo Charts. Even i was trying to change the color but no luck.

-Raghu

Red numbers in chart

johnw — Fri, 12 Jun 2009 02:55:32 GMT

It looks like the text color expression only works for text on the axis, and not for text on the data point. That might actually be a bug, since it would certainly seem like the position of the text shouldn't change it's color, and that the text color expression should be applied consistently. Well, it's easy to change the color if you put it on the axis, or to change the bar color by setting the background color with the same expression, but neither of those solutions may be acceptible.

Red numbers in chart

Fri, 12 Jun 2009 21:20:43 GMT

try doing it as a pivot then once done convert back to your chart.

possible bug..?