https://community.qlik.com/t5/App-Development/If-condition-issue/m-p/1563470#M41033 <P>hi,</P><P>&nbsp;</P><P>if(year&lt;=year(now()),yourfieldyouwant)</P><P>&nbsp;</P><P>Bye</P> Mon, 01 Apr 2019 12:39:47 GMT juliensaintmaxent3113 2019-04-01T12:39:47Z https://community.qlik.com/t5/App-Development/If-condition-issue/m-p/1563449#M41031 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 235px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/9203i2BC541814F6FE546/image-size/large?v=v2&amp;px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /></span>Hi Everyone,</P><P><EM>&nbsp;</EM>I have below table n I want to show data as second table means&nbsp;</P><P>if Year&lt; currentyear, max(year) , currentyear) for an ID</P> Mon, 01 Apr 2019 12:06:23 GMT https://community.qlik.com/t5/App-Development/If-condition-issue/m-p/1563449#M41031 New-Qlik 2019-04-01T12:06:23Z https://community.qlik.com/t5/App-Development/If-condition-issue/m-p/1563469#M41032 <P>May be this</P><P>Dimension</P><PRE>ID Name</PRE><P>Expression</P><PRE>Max(Year)</PRE> Mon, 01 Apr 2019 12:38:29 GMT https://community.qlik.com/t5/App-Development/If-condition-issue/m-p/1563469#M41032 sunny_talwar 2019-04-01T12:38:29Z https://community.qlik.com/t5/App-Development/If-condition-issue/m-p/1563470#M41033 <P>hi,</P><P>&nbsp;</P><P>if(year&lt;=year(now()),yourfieldyouwant)</P><P>&nbsp;</P><P>Bye</P> Mon, 01 Apr 2019 12:39:47 GMT https://community.qlik.com/t5/App-Development/If-condition-issue/m-p/1563470#M41033 juliensaintmaxent3113 2019-04-01T12:39:47Z