topic Re: Line chart coloring in QlikView

Line chart coloring

Mon, 04 May 2015 11:21:23 GMT

I am looking at coloring on a line chat, where everything above a variable amount is red, and below that green. The amount is a target amount which depends on selecting made in the chart, so it may be as low as a hundred thousand or may run into billions. I have looked at thread 116265 but it is not helping much as the amounts can change with selections. In short I need it to be Green where Target is reached or exceeded and Red when now reached. I do have two chart on top of each other, one with the Actual amount with data points and a dotted line with the Target amount, but now just need the coloring above and below the line

Re: Line chart coloring

sujeetsingh — Mon, 04 May 2015 11:26:47 GMT

On expression + sign click >> there will be option of Background colour.

On there write expression

if(sum(Sales)>vTarget,red(),Green())

You can write with other conditions too.

follow this thread

Change the Color of Bar depending Upon a condition not on Value

Re: Line chart coloring

Mon, 04 May 2015 11:50:49 GMT

Sujeet

That just changes the line color, not the color Above and below the line. Can you have a look at this for me.