If condition issue

[New-Qlik]

Hi Everyone,

 I have below table n I want to show data as second table means 

if Year< currentyear, max(year) , currentyear) for an ID

[sunny_talwar]

May be this

Dimension

ID
Name

Expression

Max(Year)

[juliensaintmaxent3113 · Accepted solution]

hi,

if(year<=year(now()),yourfieldyouwant)

Bye