topic Re: Graph bar colour in QlikView

Graph bar colour

danosoft — Thu, 21 Sep 2017 06:55:21 GMT

Hi i want to do a graph bar colour base -/+ value,

for example if my value is > 0 i want the bar is GREEN

if my value is < 0 i want the bar is RED

can be possible? i tried to did it with calculated colour (like you see in image) but it not start... what i do wrong?

this is the fx i used: =if(FATTURATO_IMPONIBILE>0,'#000040','#000000');

Re: Graph bar colour

prma7799 — Thu, 21 Sep 2017 07:00:03 GMT

Try this

f(FATTURATO_IMPONIBILE>0,Green(),red());

f(sum(FATTURATO_IMPONIBILE)>0,Green(),red());

Re: Graph bar colour

danosoft — Thu, 21 Sep 2017 07:04:04 GMT

Hi, thanks for reply, no it not start, but i think the function is correct, is like the graph bar not take me the calculated colour but it take the base colour, as you see in the picture i attached

Re: Graph bar colour

Gysbert_Wassenaar — Thu, 21 Sep 2017 07:05:06 GMT

The color definitions on the Colors tab are defined at the chart level, not the row level. FATTURATO_IMPONIBILE does not have a single value at the chart level so the calculation doesn't work. You can go to the expressions tab and click on the + character in front of the expression to show a list of options you can change. Click on the Background Color option and then enter your color calculation expression in the Definition field.

Re: Graph bar colour

mostwanted123 — Thu, 21 Sep 2017 07:14:45 GMT

Try this,

Go to Properties ---> Go to Expression Tab ---> Expand the Expression tab ---> Go to Background Color

In the Background Color, write the condition

if(Expression Label >0,Green(),Red())

For ex, if(Sales > 0, Green(), Red())

where Sales is label for the condition - Sum(Sales)

Regards,

Pratik

Re: Graph bar colour

danosoft — Thu, 21 Sep 2017 07:23:52 GMT

i try it but my graph not change... perhaps i need to refresh the graph? how?

Re: Graph bar colour

mostwanted123 — Thu, 21 Sep 2017 07:34:03 GMT

Try this,

if(Expression Label < 0,red(),green())

Re: Graph bar colour

danosoft — Thu, 21 Sep 2017 07:40:08 GMT

Thanks you all right now!