topic Re: Multicolor in graph in QlikView

Multicolor in graph

Mon, 30 Sep 2013 11:34:31 GMT

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

Re: Multicolor in graph

Andrea_Ghirardello — Mon, 30 Sep 2013 12:20:18 GMT

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).

Re: Multicolor in graph

Mon, 30 Sep 2013 12:23:11 GMT

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))

Re: Multicolor in graph

MayilVahanan — Mon, 30 Sep 2013 12:28:38 GMT

Try like this

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

Re: Multicolor in graph

ngulliver — Mon, 30 Sep 2013 12:32:43 GMT

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

Re: Multicolor in graph

Mon, 30 Sep 2013 12:33:18 GMT

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

Re: Multicolor in graph

techvarun — Mon, 30 Sep 2013 12:40:24 GMT

See Here

or Here

regards

Re: Multicolor in graph

israrkhan — Mon, 30 Sep 2013 12:53:39 GMT

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