topic Help with color in line graph/chart in App Development

Help with color in line graph/chart

Fri, 13 Oct 2017 16:42:17 GMT

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.

Color by measure

Color by expression. I used this expression: =IF(ExistenciaProducto < 0, RGB(255, 0, 0), RGB(40, 180, 220))

The table where I get the data has this structure:

Row Number	Date (MM/DD/YYYY)	Movement units	On Inventory
1	01/01/2017	50	50
2	01/10/2017	-25	25
3	01/10/2017	-20	5
4	02/04/2017	150	155
5	02/05/2017	-100	55

The dates are not always the same, I have one row for each movement, and I can have more than one movement per day.

Thanks!

Re: Help with color in line graph/chart

shraddha_g — Mon, 16 Oct 2017 06:49:14 GMT

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

Re: Help with color in line graph/chart

Mon, 16 Oct 2017 14:57:34 GMT

Hellor, the measure I'm using is the same, ExistenciaProducto.

Is this what you are referring to?

Re: Help with color in line graph/chart

shraddha_g — Tue, 17 Oct 2017 11:32:12 GMT

Don't you think it should be an aggregation expression?

For Ex. Sum(FieldName)

Re: Help with color in line graph/chart

Tue, 17 Oct 2017 18:14:19 GMT

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.

Re: Help with color in line graph/chart

shraddha_g — Wed, 18 Oct 2017 06:06:57 GMT

can you share sample app?

Re: Help with color in line graph/chart

Wed, 18 Oct 2017 19:56:10 GMT

This is the basic structure