How to make Bar with -ve value color change to RED ?

[paulyeo11]

Hi All,

I have a chart which have +ve and -ve value , I like to make -ve value bar color change to RED.

Can some one advise me.

Paul

[paulyeo11]

Enclosed my QS Doc

[Chanty4u]

chk attached

[paulyeo11 · Accepted solution]

Hi Chanty

Thank you for your expression below :-

If(SOURCE>0,red())

I try and found not work , suddenly i recall i have did it in QV , and i copy the script from background color expression below and it work fine :-

if(

money(

Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}profit_amt/1000)

, $(vMoneyFormatK))

-

money(

Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}Exp/1000)

, $(vMoneyFormatK))

>0, Green(), Red())

[Chanty4u]

yeah/.......i saw ur selected in ur filter as Source  so i hve given  that expression