topic Changing chart background colour depending on dimension value in QlikView

Changing chart background colour depending on dimension value

Miguel_Angel_Baeyens — Sun, 13 Dec 2009 19:17:05 GMT

Good day everyone again!

I have several charts (straight tables and pivot tables, but specially straight tables) in which I want to change the background colour depending on the dimension value.

For instance, I've got a "Day" dimension, and I thought to customize the colour in the dimension controlling odd and even days. But it's possible to have two even consecutive days or two odd consecutive days, so my conditional won't work as I want to change background every time the value changes. Speaking about days,

01/01/2010

02/01/2010

Would change only in the third line. I haven't managed to do that. Anyone can shed some light on how to do it?

Thanks!

Changing chart background colour depending on dimension value

Sun, 13 Dec 2009 20:11:01 GMT

Can you attach small example to work on?

Changing chart background colour depending on dimension value

Sun, 13 Dec 2009 20:16:05 GMT

As far as I can see you will only be able to change background colours every set number of lines...

Changing chart background colour depending on dimension value

prieper — Mon, 14 Dec 2009 04:50:54 GMT

Good Day,

you may for each dimension click on the small "+" and enter under "Background" something like

=IF(Date <> ABOVE(Date), LIGHTBLUE())

Instead of LIGHTBLUE() you may choose with RGB(n, n, n) your own colours

HTH
Peter

Changing chart background colour depending on dimension value

Miguel_Angel_Baeyens — Mon, 14 Dec 2009 15:26:47 GMT

Hi Peter,

Thanks for the idea, but unfortunately, it doesn't work. I'll keep thinking about it but new suggestions are welcome!

Changing chart background colour depending on dimension value

Miguel_Angel_Baeyens — Wed, 16 Dec 2009 16:54:25 GMT

As far as I know, and regarding the tests I have performed, changing colours this way works for pivot tables but not straight tables. Do you know how to do it? Maybe with some before() or after() plus below() and above()?

Changing chart background colour depending on dimension value

Thu, 01 Sep 2011 11:41:22 GMT

Hi Miguel,

I was doing the same thing and this above() does not work on Straighttable. Did you find any solution in this two years for this problem?

Thanks in Advance

Sravan

Changing chart background colour depending on dimension value

Miguel_Angel_Baeyens — Thu, 01 Sep 2011 15:38:50 GMT

Hi Sravan,

I worked that around using the conditionals as suggested by Peter above. Anyway, that was a bug in the version. If you post some sample data we can check and see how it behaves and if we can find the review the issue.

Regards,

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica