Conditional colors question

[#1]

Question regarding conditional colors in a graph. Ive set the color of the bars to conditional. It should turn dark red when its value exceeds the other expresion, seen as the dotted line.

i.e.

if(expresion 1 > expresion 2), Red()   

Now it turns the whole bar red instead of only the part above the line, is this possible to do in QV?

[#2]

Hi,

Since you can't cut a bar in two if an expression exceeds another, you would have to add a metric and make a stacked bar chart so that the first metric has a maximum value up until the dotted line and then the second metric would be the value higher than the dotted line.. Haven't tried this, but can't see how it would work otherwise...

BR

/Pierre

[julian_rodriguez · Accepted solution]

Hello, Using the Pierres idea , I made this. Please see attachment.