Multicolor in graph

[#1]

I have buildup a graph with, three expression in it. Qlikview assigned different color to each expression. One of my expression result into positive and negetive values. I need to refelct positive with different color and negetive with deifferent one.. Please Help

i have fair Idea of Data Appearance, and persistent color .. but unable to split one expression result in multi color. ?

Appreciate your comments..sss

[Andrea_Ghirardello]

You can use Visual Cues rules.

For each expression you can define forecolor and backcolor according to your needs (e.g. for numbers <= 0 you can define backcolor red).

[#3]

In the expression tab you can open each expression.

If you do so you can set a conditional to the text color.

Adding an if-statement will do the trick.

For example:

If(Value>0, RGB(0,255,0), RGB(255,0,0))

[MayilVahanan]

Hi

Try like this

In that, = If( Sum(Sales) < 0, Red(), Green())

[ngulliver]

Hi, Atiq.

Have you tried using the Background Colour in the Expression ?

Click on the + on the Exoression to opeon up additional options. Within Background Colour put the code below (substituting Fieldname with the expression name)

if(Fieldname > 0, rgb(200, 0, 0), rgb(0, 200, 0))

This should mean positive numbers are green and negative numbers are red.

Regards,

Neil

[#6]

Hi

goto expression tab -click on + on expression(expand the expression)

select back ground color-in the defintion write if condition like below

if(sum(Sales)>200000,red())

if u need negetive values in red color then follow below cond

if(sum(Sales)<0,red())

if ur using pivot or straight tables then

goto visual cues tab-give upper and lower values

for negetive values ,enter 0 as  lower value and select color red

[techvarun]

See Here

or Here

regards

[israrkhan]

Hi Atiq,

in chart properties, Expression Tabe , Expend the expression>> background color, and write expression here.

like= if(sum(Value)>=0, Green(), Red())

Image below:

Khan