How to remove current year line value on data point ?

[#1]

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 ?

[#2]

Hi All

enclosed my QV doc

[MK_QSL]

Go to expression

CLick on +

under Show Value write below expression

year = 2013

[Anonymous]

Try this expression.

money(

Sum(

{<Year={'2013'}>}

sales/$(Columndim89)/1000)

, $(vMoneyFormatK))

[Gysbert_Wassenaar · Accepted solution]

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))

[#6]

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

[Gysbert_Wassenaar]

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.

[#8]

Hi Sir

if(year=2014,lightgray(1),black())

I try above , because i want 2014 lightgray and 2013 black

but not working. pls help.

[Gysbert_Wassenaar]

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())

[#10]

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 ?