topic Re: List Box - show only most recent 3 months in QlikView https://community.qlik.com/t5/QlikView/List-Box-show-only-most-recent-3-months/m-p/697149#M251800 <HTML><HEAD></HEAD><BODY><P>use expression</P><P></P><P>if (monthstart(mydates) &gt; monthstart(addmonths(today(),-3)), mydates)</P></BODY></HTML> Thu, 25 Sep 2014 14:39:05 GMT Anonymous 2014-09-25T14:39:05Z List Box - show only most recent 3 months https://community.qlik.com/t5/QlikView/List-Box-show-only-most-recent-3-months/m-p/697148#M251799 <HTML><HEAD></HEAD><BODY><P>I've got a list box that has the Month Year going back to May 2013 and will continue to include more recent months as time goes on.</P><P></P><P>i.e.</P><P><IMG alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/67648_pastedImage_0.png" style="width: auto; height: auto;" /></P><P></P><P>I want to use an expression to show only the most recent 3 months. This can either be based on today's date or simply the most recent 3 months as this will give the same result.</P></BODY></HTML> Thu, 25 Sep 2014 14:34:26 GMT https://community.qlik.com/t5/QlikView/List-Box-show-only-most-recent-3-months/m-p/697148#M251799 shane_spencer 2014-09-25T14:34:26Z Re: List Box - show only most recent 3 months https://community.qlik.com/t5/QlikView/List-Box-show-only-most-recent-3-months/m-p/697149#M251800 <HTML><HEAD></HEAD><BODY><P>use expression</P><P></P><P>if (monthstart(mydates) &gt; monthstart(addmonths(today(),-3)), mydates)</P></BODY></HTML> Thu, 25 Sep 2014 14:39:05 GMT https://community.qlik.com/t5/QlikView/List-Box-show-only-most-recent-3-months/m-p/697149#M251800 Anonymous 2014-09-25T14:39:05Z