topic Color in bar Chart depending on prefix in QlikView

Color in bar Chart depending on prefix

Wed, 30 Mar 2011 06:55:30 GMT

Hallo,

i have the following Problem:

I have a bar chart, with e.g. the Return on Investment (ROI) .

My dimension is a Drill-Down group, like company, Produkt, ...

and i want the graph to be red, if the ROI ist negative,

and the graph to be green. if the ROI is positive.

I tried it, like :

Colors, pick up the first color and put into the following

formula: if (sum (ROI)>0 , green(),red())

But the graphs allways are green or red at all,

not like wanted.

So is there anybody,who may help me (if there is anybody who

speaks German,....that would be nice;)

Thanks

Color in bar Chart depending on prefix

Miguel_Angel_Baeyens — Wed, 30 Mar 2011 07:41:44 GMT

Hello,

Go to the Expressions tab, and expand clicking on the [+] sign at the left of the expression you want to change. You will see "Background Color". Set the condition there.

Hope that helps.

Color in bar Chart depending on prefix

Wed, 30 Mar 2011 07:59:25 GMT

Thanks,...it works,...i looked at the wrong place 😉