topic Conditional Color for Stacked Bar Expression in QlikView

Conditional Color for Stacked Bar Expression

cdunham — Wed, 02 Dec 2020 22:44:15 GMT

This is my first post and I am very new to QlikView so let me know if I need to add anything else. I have a combo chart with some stacked bars. I need one of the expressions to change color if it is greater or lower than 0. The expression is

Sum({$<Revenue.Source={'Forecast'},[Date]={">$(vMaxBookedDate)"}>}Revenue.Price)-Sum({$<Revenue.Source={'SABA', 'SABA Valencia','SpecialContracts'},[Date]={">$(vMaxBookedDate)"}>}Revenue.Price)

I have tried

if((Sum({$<Revenue.Source={'Forecast'},[Date]={">$(vMaxBookedDate)"}>}Revenue.Price)-Sum({$<Revenue.Source={'SABA', 'SABA Valencia','SpecialContracts'},[Date]={">$(vMaxBookedDate)"}>}Revenue.Price))>0,RGB(180,23,30),RGB(0,0,0))

This did not work. Any recommendations would be appreciated.

Re: Conditional Color for Stacked Bar Expression

edwin — Thu, 03 Dec 2020 00:05:04 GMT

that should work. of course you added it in the background of the expression - rt? otherwise, pls attach a QVW.

Re: Conditional Color for Stacked Bar Expression

cdunham — Thu, 03 Dec 2020 14:07:46 GMT

I was trying to put it into the color itself on the colors tab. Putting it into the expressions background color made it work. Thank you!

Re: Conditional Color for Stacked Bar Expression

edwin — Thu, 03 Dec 2020 14:36:47 GMT

youre welcome