Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Changing color by measure

Hi all, I have a problem where I want to change the color of the measures separately. Please see the chart below. I want to set all triangles as red if they are above the horizontal line and green if they are below the horizontal line. I want the color of the horizontal line to be red. Right now the line is green. My color expression is the following:

if(triangle>UpperLimit,red(),green())

You can see that the one red triangle below. The corresponding segment of the horizontal line is also red. How can I express the color so that the entire horizontal line is red, and that all triangles above the line is red and all triangles below it is green?

Thanks.

11 Replies
Not applicable
Author

Thanks for your suggestion SNC. But I am using Qlik Sense which does not have this capability.

Not applicable
Author

well that's a different beast then