topic Re: Filter in App Development https://community.qlik.com/t5/App-Development/Filter/m-p/74390#M4947 <HTML><HEAD></HEAD><BODY><P>Could be this:</P><P></P><P>If (YearField&gt;=Max(total YearField,3),YearField)</P></BODY></HTML> Sun, 08 Apr 2018 20:03:35 GMT Thiago_Justen_ 2018-04-08T20:03:35Z Filter https://community.qlik.com/t5/App-Development/Filter/m-p/74387#M4944 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I want Qliksense filter to display latest 3 year value. Please let me know how can i do that.</P><P></P><P>THanks,</P><P>Monu</P></BODY></HTML> Sun, 08 Apr 2018 11:43:42 GMT https://community.qlik.com/t5/App-Development/Filter/m-p/74387#M4944 sarasmonu 2018-04-08T11:43:42Z Re: Filter https://community.qlik.com/t5/App-Development/Filter/m-p/74388#M4945 <HTML><HEAD></HEAD><BODY><P>=Aggr( If( Only(Year) &gt;= Max(TOTAL Year,3) , Year) , Year)</P></BODY></HTML> Sun, 08 Apr 2018 11:57:22 GMT https://community.qlik.com/t5/App-Development/Filter/m-p/74388#M4945 petter 2018-04-08T11:57:22Z Re: Filter https://community.qlik.com/t5/App-Development/Filter/m-p/74389#M4946 <HTML><HEAD></HEAD><BODY><P>May be</P><P></P><P>=IF(YourYearField &gt;= Max({1}Total YourYearField )-2,YourYearField )</P></BODY></HTML> Sun, 08 Apr 2018 12:55:14 GMT https://community.qlik.com/t5/App-Development/Filter/m-p/74389#M4946 MK_QSL 2018-04-08T12:55:14Z Re: Filter https://community.qlik.com/t5/App-Development/Filter/m-p/74390#M4947 <HTML><HEAD></HEAD><BODY><P>Could be this:</P><P></P><P>If (YearField&gt;=Max(total YearField,3),YearField)</P></BODY></HTML> Sun, 08 Apr 2018 20:03:35 GMT https://community.qlik.com/t5/App-Development/Filter/m-p/74390#M4947 Thiago_Justen_ 2018-04-08T20:03:35Z