topic Re: changing colours on chart when values below 0 on y-axis in QlikView

changing colours on chart when values below 0 on y-axis

Fri, 20 Feb 2015 15:05:22 GMT

is there nice easy way of changing colours on the following line chart when the value drops below 0 on the y-axis, either by changing colour of line or the symbols dots?

I'll also what it applied to the columns in the bar chart when they drop below 0 as this is a Fast Type Change chart!!

if below 0 I want it to change to red etc

Re: changing colours on chart when values below 0 on y-axis

MK_QSL — Fri, 20 Feb 2015 15:14:40 GMT

Check enclosed file..

Re: changing colours on chart when values below 0 on y-axis

awhitfield — Fri, 20 Feb 2015 15:27:52 GMT

You could try something like this, it actually works better on a bar chart 🙂

Re: changing colours on chart when values below 0 on y-axis

awhitfield — Fri, 20 Feb 2015 15:29:14 GMT