topic Re: 2 colored line in Line Chart in QlikView

2 colored line in Line Chart

Wed, 17 Sep 2014 20:58:44 GMT

Is it possible to use the Colors tab and/or Background Color/Line Style attributes to assign multiple colors to a single line as shown in the attached chart?

Thanks!

Re: 2 colored line in Line Chart

JonnyPoole — Thu, 18 Sep 2014 00:59:17 GMT

How about like this ? its a regular line chart with 'multicolored' enabled and a line style of '<W8>'

or 3D ?

Re: 2 colored line in Line Chart

Thu, 18 Sep 2014 15:55:30 GMT

I believe that each of those segments is a seperate line. If you look at my example, each line needs to to have two colors and they need to be in a gradient as they move across the line. I could create two lines for every line, but it wouldn't allow for the gradients and would not be ideal as every line in my data would be split in two.

Re: Re: 2 colored line in Line Chart

JonnyPoole — Thu, 18 Sep 2014 16:14:41 GMT

This is a continuous line chart (numeric / date dimension) and i've added a colormix1() color gradient with the following formula.

it takes a value between 0 and 1, so the date on the x axis is a ratio of the min->max range. Left side is yellow() and right side is red().

is this helpful ?

ColorMix1(

(Date - min( total Date))

( max( total Date) - min(total Date) )

,yellow(),red())

Re: 2 colored line in Line Chart

vgutkovsky — Thu, 18 Sep 2014 16:20:23 GMT

You can probably use colormix1 to accomplish what you need, assuming you have just 2 colors in your gradient (which it seems like you do from your screenshot):

ColorMix1(rand(),blue(),red())

You can use the first parameter to determine how much closer the color should be to the first color vs. the second.

Regards,

Vlad