Hi, I just started to use Qlik Sense and I want to personalize the colors in a line graph/chart, according to the value of the expression.
I want to change the color of the line depending on the value. If the value is lower than zero, I need one color, and if the value is higher than zero, I need another color. I only get the result of the picture, but it is not exactly what I want.
I have tried two different methods.
The table where I get the data has this structure:
|Row Number||Date (MM/DD/YYYY)||Movement units||On Inventory|
The dates are not always the same, I have one row for each movement, and I can have more than one movement per day.
In your expression --> IF(ExistenciaProducto < 0, RGB(255, 0, 0), RGB(40, 180, 220))
instead of ExistenciaProducto, put a expression you have used in Measure section of chart
I changed it, "RangeSum(Above(Sum(Units), 0, RowNo()))" instead "Sum(Inventory)"
It works at the same way, even with this aggregation expression as the measure for the chart and for the colour condition.