Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Conditional colors question

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?

save.png

1 Solution

Accepted Solutions
julian_rodrigue
Valued Contributor

Re: Conditional colors question

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

community.png

2 Replies
Not applicable

Re: Conditional colors question

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_rodrigue
Valued Contributor

Re: Conditional colors question

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

community.png