https://community.qlik.com/t5/QlikView/Max-date/m-p/1631339#M732574 <P>Try this:</P><P>Under actions:</P><P>insert&nbsp;<SPAN>max({1}year)</SPAN></P> Fri, 04 Oct 2019 06:36:11 GMT Arthur_Fong 2019-10-04T06:36:11Z https://community.qlik.com/t5/QlikView/Max-date/m-p/1631329#M732573 <P>Hi All,</P><P>I have year field starting from from 200 7 onwards but in a list box i have to show it from 2016 onwards to do so</P><P>in a list box under expression i am writing like if(year &gt;'2015',Year) . this is showing the correct results .i see year from 2016 to 2019 ,</P><P>I have a button which i am using to clear the selection. under actions i am writing like max(year) and when i am clicking on it this is not working (not selecting the 2019 year)<BR />becuase in a list box i have not selected direct field values .<BR />Can you expertise suggest me how do i sepcify this clear button , so that when i click on it it should make 2019 t get selected ?</P><P>Thanks in advance</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Max-date/m-p/1631329#M732573 smilingjohn 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Max-date/m-p/1631339#M732574 <P>Try this:</P><P>Under actions:</P><P>insert&nbsp;<SPAN>max({1}year)</SPAN></P> Fri, 04 Oct 2019 06:36:11 GMT https://community.qlik.com/t5/QlikView/Max-date/m-p/1631339#M732574 Arthur_Fong 2019-10-04T06:36:11Z