topic List Box Expression in QlikView https://community.qlik.com/t5/QlikView/List-Box-Expression/m-p/1165391#M521001 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P>I have a list box properties which is looking for a dimension calendar year, from 2011 to 2020</P><P>I want to use field as a expression and use a formula that only shows 3 years prior the current. Does anyone knows which formula can I use?</P><P></P><P>Thanks</P><P>Joanna</P></BODY></HTML> Thu, 28 Jul 2016 07:03:58 GMT 2016-07-28T07:03:58Z List Box Expression https://community.qlik.com/t5/QlikView/List-Box-Expression/m-p/1165391#M521001 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P>I have a list box properties which is looking for a dimension calendar year, from 2011 to 2020</P><P>I want to use field as a expression and use a formula that only shows 3 years prior the current. Does anyone knows which formula can I use?</P><P></P><P>Thanks</P><P>Joanna</P></BODY></HTML> Thu, 28 Jul 2016 07:03:58 GMT https://community.qlik.com/t5/QlikView/List-Box-Expression/m-p/1165391#M521001 2016-07-28T07:03:58Z Re: List Box Expression https://community.qlik.com/t5/QlikView/List-Box-Expression/m-p/1165392#M521002 <HTML><HEAD></HEAD><BODY><P>Hi Joanna,</P><P></P><P><STRONG>=If(Year &lt;= Year(Today()) and Year &gt;= Year(Today())-3, Year)</STRONG></P><P></P><P>Or</P><P></P><P><STRONG>=Aggr(Only({&lt;Year={"&gt;=$(=Year(Today())-3)&lt;=$(=Year(Today()))"} &gt;}Year),Year)</STRONG></P></BODY></HTML> Thu, 28 Jul 2016 08:33:55 GMT https://community.qlik.com/t5/QlikView/List-Box-Expression/m-p/1165392#M521002 tamilarasu 2016-07-28T08:33:55Z Re: List Box Expression https://community.qlik.com/t5/QlikView/List-Box-Expression/m-p/1165393#M521003 <HTML><HEAD></HEAD><BODY><P>Thanks so much Tamil appreciate your help <span class="lia-unicode-emoji" title=":grinning_face_with_big_eyes:">😃</span></P></BODY></HTML> Thu, 28 Jul 2016 22:09:31 GMT https://community.qlik.com/t5/QlikView/List-Box-Expression/m-p/1165393#M521003 2016-07-28T22:09:31Z Re: List Box Expression https://community.qlik.com/t5/QlikView/List-Box-Expression/m-p/1165394#M521004 <HTML><HEAD></HEAD><BODY><P>Anytime. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> Kindly close the thread, if your query was answered. <SPAN style="font-size: 13.3333px;">Thank you and have a nice day.</SPAN></P><P></P><P><A href="https://community.qlik.com/docs/DOC-14806">Qlik Community Tip: Marking Replies as Correct or Helpful</A></P></BODY></HTML> Fri, 29 Jul 2016 03:00:32 GMT https://community.qlik.com/t5/QlikView/List-Box-Expression/m-p/1165394#M521004 tamilarasu 2016-07-29T03:00:32Z