Edit show value in expression

[Anonymous]

Hi QVs,

I was trying to show only the values of a line chart which follow a condition, for example those that are in 2014. I edit the expression in show value with: =if(year(datefield)='2014', 1,0)    but it doesn't work.

I found some discussions about it but i couldn't get a solution. Any idea?

Thanks for helping.

Marc.

[tresesco · Accepted solution]

Or, even simpler:

=Max(Year(FechaEncuesta)=2014)

[Anonymous]

Tresesco, you are definitely right. I was originally working more along the lines of the attached example.

Hence the full expression.

ONLY(Year(FechaEncuesta))=2013 is another alternative to MAX

Kind regards

Niklas

[Anonymous]

Works fine. Thanks.