topic Variable Color for Line Chart in QlikView

Variable Color for Line Chart

pbaenen — Wed, 16 Sep 2009 23:38:29 GMT

Is it possible to dynamically change the color of the line in a line chart?

For example, can I have the first x values be red, and the rest be black?

Variable Color for Line Chart

Wed, 16 Sep 2009 23:45:40 GMT

Yes, go to the Colors tab of your chart properties, click on one of the colors and put in a calculated color. You have a separate color for the first 18 lines, so you would have to define all the ones you wanted as red to be red and the rest black. You could use a variable to make the number of red lines be dynamic,

Variable Color for Line Chart

pbaenen — Thu, 17 Sep 2009 00:02:13 GMT

I've tried the Calculated color, but I'm not sure what to put in for the formula to give me, for example, the first 5 values of the chart.

I assume I should be using an If statement here.

Variable Color for Line Chart

Thu, 17 Sep 2009 00:08:11 GMT

One other option:

Go to Expression Tab.

Expand the expression.

Select the Background color

Add a condition if(rowno()<10 ,RGB(0,236,0),RGB(255,100,255))

Note: This won't work if the graph is sorted according to y value.

Variable Color for Line Chart

pbaenen — Thu, 17 Sep 2009 00:19:58 GMT

Thank you, this was exactly what I was looking for.