topic Re: requirement in QlikView

requirement

Anonymous — Wed, 09 May 2018 06:25:46 GMT

i have a bar chart which shows some negative values and some positive

what I want now that positive values shud be displayed in green color and negative values in red color,

tresB — Wed, 09 May 2018 06:33:00 GMT

Use background expression something like:

If(Sum(Value)>0, Green(), Red())

Anonymous — Wed, 09 May 2018 06:39:49 GMT

thanks ,where shud I put this condition ,

where I have written the expression?

jonathandienst — Wed, 09 May 2018 06:42:35 GMT

Click the + next to the expression in the chart properties and set a colour expression for the background colour. Something like

If(...your expression here... < 0, Red(), Green())

tresB — Wed, 09 May 2018 06:45:22 GMT

Check the screen shot. Click on the 'Background Color'.