Qliksense - Chart columns colour based on positive or negative values

[toby_booth]

Hello all,

This seems simple to me but I still cannot find a solution. In a simple bar chart, I have Profit and Loss figures. I would like to show each column as a different colour depending on whether the value is positive or negative.

Green for Positive, and Red for Negative.

I have attempted to use the Expression formulas for the actual data point with simple If...Then statements e.g. sum(item>0,Green(),Red())and the same in the Appearence>>Colors and legend options. Nothing works for me.

Is this a solved issue? I couldn't find a solution after hours of searching.

Thanks.

[vmoreno2605]

This is what you can do

if(yourvalue>0,green(),red())

In this option

I hope this helps

[toby_booth]

As you can see in the image, the issue is that there are two elements in the bar chart. Using that expression affects ALL the elements, where as I only want one affected. Is there a solution for this?

[MK9885]

if(YOUREXPRESSION>0,green(),red())