Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I like to make the line chart display :-
1. When the net profit amount is -ve it shown red color line.
2. when the net profit amount is +ve it shown black color line.
Now it display whole line red color.
Paul
Hi Paul,
I think, you have to use your expression, instead of sum([NET_PROFIT)). i.e.,
if( (sum({$<year = {">=$(=max(year),4)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}NET_PROFIT/$(Columndim89)/1000)) < 0, red(), Black())
Thanks,
Vinod Kumar V
Hi All
Enclosed my QV doc
Hi,
add expression at back ground color
=if(sum[net profit]<0,red(),Black())
I don't see any line (its showing no data to display) and I tried clearing out any selection and still says the same.
Hi Sir
=if
(
sum([NET_PROFIT]<0,red(),Black()
)
)
I try above like what you said , but it still not work.
Paul
there is a formatting error in the expression you have mentioned. You have misplaced the bracket. Please refer my expression above.
Hi Paul,
I think, you have to use your expression, instead of sum([NET_PROFIT)). i.e.,
if( (sum({$<year = {">=$(=max(year),4)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}NET_PROFIT/$(Columndim89)/1000)) < 0, red(), Black())
Thanks,
Vinod Kumar V
also in the qvw you have attached there is no data to display in the chart as mentioned above.
You may try using Vinod Kumar's expression at background color.
Hi Kumar
it work , thank you vey much
ywc