topic Chart Line to change colour in QlikView

Chart Line to change colour

Fri, 11 Dec 2015 08:12:07 GMT

Hi,

I can have the following chart:

From 14.00 hours I want the blue line to go white.

I've tried to write the following expression for the Background Colour, but it doesnt change anything.

if (Hour>'14', RGB (255,255,255), RGB(0,123,255))

Any ideas folks?

Thanks.

Re: Chart Line to change colour

MK_QSL — Fri, 11 Dec 2015 09:50:15 GMT

May be try as below

if (Hour>14, RGB (255,255,255), RGB(0,123,255))

or what is the format of your Hour?

Re: Chart Line to change colour

Anonymous — Fri, 11 Dec 2015 09:52:45 GMT

Syntax looks okay, the only thing you need to check the format compatibility.

Make sure Format of Hour and 14 should be same

Re: Chart Line to change colour

Fri, 11 Dec 2015 11:39:46 GMT

How can I get the format to be the same?

Thanks

Re: Chart Line to change colour

Fri, 11 Dec 2015 11:44:00 GMT

Hi deep,

your syntax is correct,

if possible to share your date field values

Re: Chart Line to change colour

rubenmarin — Fri, 11 Dec 2015 11:56:57 GMT

Hi, from the straigth line after '14' seems that expression is full accumulated and there is no data for hour>14 so it keeps the last value, maybe using:

if (Hour>14 or IsNull(Hour), RGB (255,255,255), RGB(0,123,255))

Re: Chart Line to change colour

Fri, 11 Dec 2015 13:10:05 GMT

No it didnt work

Re: Chart Line to change colour

krishna20 — Fri, 11 Dec 2015 14:18:01 GMT

Hi,

Try like this ,

Expand your expression ->Select Background Color->if (Hour>=14, RGB (255,255,255), RGB(0,123,255)).

I tried in my app as per my requirement. Please you try with your values.

Edited : My experession is like this

=if((Sum({<Category_ID={'Cat_002'}>}Value))>=750,RGB(181,230,89),Blue()).

Re: Chart Line to change colour

MK_QSL — Sat, 12 Dec 2015 08:59:51 GMT

Define vHour as

=Time#('13','hh')*24

Dimension

=Floor(Frac([Arrival DateTime])*24)

Use below expression for color

IF(Floor(Frac([Arrival DateTime])*24)>=vHour,White(),Green())

Change Green() to whatever colour want.

Re: Chart Line to change colour

MarcoWedel — Sat, 12 Dec 2015 12:29:38 GMT

‌maybe helpful

Re: Coloring line chart by two dimension

regards

Marco

Re: Chart Line to change colour

Mon, 14 Dec 2015 13:16:26 GMT

This looked like it would work, but still doesnt