topic Re: Qliksense - Chart columns colour based on positive or negative values in App Development

Qliksense - Chart columns colour based on positive or negative values

toby_booth — Sat, 16 Nov 2024 07:21:01 GMT

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.

Re: Qliksense - Chart columns colour based on positive or negative values

vmoreno2605 — Mon, 05 Nov 2018 18:02:59 GMT

This is what you can do

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

In this option

I hope this helps

Re: Qliksense - Chart columns colour based on positive or negative values

toby_booth — Thu, 08 Nov 2018 08:43:13 GMT

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?

Re: Qliksense - Chart columns colour based on positive or negative values

MK9885 — Thu, 08 Nov 2018 18:06:38 GMT

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