Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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())
Enclosed my QS Doc
chk attached
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())
yeah/.......i saw ur selected in ur filter as Source so i hve given that expression