Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
My chart only have 1 expression. and it display 2013 sales trend and 2014 sales trend.
I only want 2013 sales value display at data point , how to do it ?
Click on the + in front of the expression, choose Text Color and enter as Definition this expression: if(year=2013,white(0),black())
Or this one: if(year=2014,black(),white(0))
Hi All
enclosed my QV doc
Go to expression
CLick on +
under Show Value write below expression
year = 2013
Try this expression.
money(
Sum(
{<Year={'2013'}>}
sales/$(Columndim89)/1000)
, $(vMoneyFormatK))
Click on the + in front of the expression, choose Text Color and enter as Definition this expression: if(year=2013,white(0),black())
Or this one: if(year=2014,black(),white(0))
Hi All
Thank you for all your reply. it work fine now. I hv follow up question , may i know how to make the line color as my wish , for example 2014 red and 2013 gray. of cos i can change to any other color i need in future.
Paul
Click on the + in front of the expression, choose BackgroundColor and enter as Definition =if(year=2014,red(), if(year=2013, lightgray())) or use lightred() for reds and for example rgb(150,150,150) for grays.
Hi Sir
if(year=2014,lightgray(1),black())
I try above , because i want 2014 lightgray and 2013 black
but not working. pls help.
lightgray(1) will give the lightgray color an alpha value of 1, which will make it almost 100% transparent. Try just if(year=2014,lightgray(),black())
Hi Sir
For with out maintenance , i need to use year equal current year expression below :-
<Year={'>$(=year(today())-0)'}>
I assume below code should do the work , but cannot work :-
if(<Year={'>$(=year(today())-0)'}>,lightgray(),black())
Can advise me ?