topic Re: Select the last X Date in QlikView https://community.qlik.com/t5/QlikView/Select-the-last-X-Date/m-p/473331#M1149132 <HTML><HEAD></HEAD><BODY><P>see the attached file</P><P>hope it helps you</P></BODY></HTML> Fri, 14 Jun 2013 12:03:06 GMT er_mohit 2013-06-14T12:03:06Z Select the last X Date https://community.qlik.com/t5/QlikView/Select-the-last-X-Date/m-p/473329#M1149130 <HTML><HEAD></HEAD><BODY><P>I want click view to choose the previous months but don't know how to tell it.&nbsp; For example, Today is June 15th, I want qlikview to give me the previous 5 months.&nbsp; When the date is July 18th, I want it to give me the previous 6 months, etc.</P><P></P><P>Any help is appreciated.</P></BODY></HTML> Fri, 14 Jun 2013 11:31:29 GMT https://community.qlik.com/t5/QlikView/Select-the-last-X-Date/m-p/473329#M1149130 2013-06-14T11:31:29Z Re: Select the last X Date https://community.qlik.com/t5/QlikView/Select-the-last-X-Date/m-p/473330#M1149131 <HTML><HEAD></HEAD><BODY><P>try this</P><P>sum({&lt;Date = {"&gt;=$(=MonthStart(Max(Date), -5))&lt;=$(=MonthEnd(Max(Date)))"},DATE=,Year=,Month=&gt;}Sale)</P></BODY></HTML> Fri, 14 Jun 2013 11:38:16 GMT https://community.qlik.com/t5/QlikView/Select-the-last-X-Date/m-p/473330#M1149131 2013-06-14T11:38:16Z Re: Select the last X Date https://community.qlik.com/t5/QlikView/Select-the-last-X-Date/m-p/473331#M1149132 <HTML><HEAD></HEAD><BODY><P>see the attached file</P><P>hope it helps you</P></BODY></HTML> Fri, 14 Jun 2013 12:03:06 GMT https://community.qlik.com/t5/QlikView/Select-the-last-X-Date/m-p/473331#M1149132 er_mohit 2013-06-14T12:03:06Z