topic Re: Problem with bar chart color in QlikView

Problem with bar chart color

Sat, 02 Jul 2011 12:15:19 GMT

I experts,

I want to color my bar in function of the value of my data "Delta" but when I write my code in the calculated base color 1 (of 1-6), it doens't work.

My code : if(Delta < 100,red())

The result is blue when my value = 56...

Could you help me please ?

Best regards,

Pierre.

Problem with bar chart color

Anonymous — Sat, 02 Jul 2011 12:32:24 GMT

Hi Pierre,
Not enough enformation, so I'm just trying to guess, hope it at least will give you directions.
Apparently something is wrong with "Delta" - it is not what you expect here. What is the bar expression itslef? If it is, for example, sum(Delta), the color expression should be if(sum(Delta) < 100,red()).

Regards,
Michael

Re: Problem with bar chart color

neetu_singh — Mon, 04 Jul 2011 05:56:50 GMT

Hi,

In Expression use sum(Delta) and then click on "+" at Expression tab and on Background Color write this expression:

if(Sum(Delta)<'100',rgb(255,0,0)). It will work.as mention below

Please find attached sheet.

Regards

Neetu SIngh

Re: Problem with bar chart color

Wed, 28 Nov 2012 17:52:25 GMT

Neetu,

Thanks a lot for the information. Its really helpful.

Regards

Siva Rama