topic Re: Colors in styled line chart in QlikView

Colors in styled line chart

Tue, 20 Aug 2013 14:30:45 GMT

Hi, Community!

How can I color line chart like on this pic? I have tried all scenario that I knew.

rustyfishbones — Tue, 20 Aug 2013 14:45:16 GMT

this video may help

Qlikview Line Color Tip

Thu, 22 Aug 2013 06:57:43 GMT

For this styled line chart does not work.

Thu, 22 Aug 2013 07:20:19 GMT

Hi,

I think it's possible by setup the color under expression (expand it by press '+' mark) -> Background color and use the defination.

sujeetsingh — Thu, 22 Aug 2013 09:52:28 GMT

Eager to know this !1

Brice-SACCUCCI — Thu, 22 Aug 2013 13:05:34 GMT

Hi,

What about this ?

Brice-SACCUCCI — Thu, 22 Aug 2013 13:25:42 GMT

Some details :

1. Create an area chart with 3 expressions :

- if((Value) < 0, sum(Value), 0) : Negative values, background color "white(0)" (transparent)

- 0 : 0 values, background color "Red()"

- if(sum(Value) >= 0, sum(Value), 0) : Positive values, background color "Green()"

2. You'll see that the lines are not continuous between Green and Red. You have to generate intermediate values when the line cross the 0 Y-Axis.

I do this in the script, using the Thales' Theorem!

ValuesTmp:

JOIN

LOAD

fabs(PrevValue) * (Dim - PrevDim) / (fabs(Value - PrevValue)) + PrevDim as Dim,

0 as Value;

LOAD

num(Previous(Dim)) as PrevDim,

num(Dim) as Dim,

Previous(Value) as PrevValue,

Value as Value

RESIDENT

Values

WHERE (Previous(Value) * Value) < 0; // Only compute when the sign of the value changes

Thu, 22 Aug 2013 14:04:57 GMT

Nice.