topic Calculated Bar Colours on Chart in QlikView

Calculated Bar Colours on Chart

Thu, 06 Aug 2009 13:09:02 GMT

I have a chart with a target. If the sum of the field is greater than 98 I want the bar to be green if its below this I want it to be red. I have used this calculation but it doeswn't work, is this possible?

(Sum ([Yield %]) > 98,Green(),Red())

AW:Calculated Bar Colours on Chart

Thu, 06 Aug 2009 13:33:25 GMT

Have you insert the code into "Background colour", the sub-point underneath dimension- and formula-name?

See attached example.

Calculated Bar Colours on Chart

Thu, 06 Aug 2009 13:36:49 GMT

Hi,

see the attached example.

Good luck!

Rainer

Calculated Bar Colours on Chart

Fri, 07 Aug 2009 11:52:52 GMT

Thanks guys. As I posted the question i tried the background colour under expressions and it worked. I was doing it on the colour tab originally.

Thanks for your replies

Calculated Bar Colours on Chart

Tue, 10 May 2011 18:48:27 GMT

Hi,

Can you please send me the attachment in an email as i am unable open the file downloaded from here.

Thanks

Arun

Re: AW:Calculated Bar Colours on Chart

Wed, 18 Mar 2015 11:00:19 GMT

Thanks Rainer, that saved me a lot of time., great example