Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
azucna122
Partner - Creator
Partner - Creator

colour a negative value that is positive in red

Hi I am new to qlik, i am trying to make a graph that represents negative and positive values, I have succeeded with the expression:
= if(count(product) > 0, green(),
if(Fabs(count(product) > 0) * -1, red())))

My problem is that I don't know how to paint the negative values, since they are not negative values as such, because I have forced them with the Fabs() *-1 function.
Does anyone know how to colour those positive values converted to negative values? as shown in the img

 

azucna122_0-1674812140280.png

 

10 Replies
azucna122
Partner - Creator
Partner - Creator
Author

hello ogster1974,
a question, do you know if you can remove the space that I highlight in blue?
if it can be seen by a scale more together and not so separated the bars

azucna122_0-1675326277837.png