topic Re: Previous 3 Months Data in QlikView https://community.qlik.com/t5/QlikView/Re-Previous-3-Months-Data/m-p/746891#M1024905 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need to show in a table only the data for last 3 months. without any selection it should show the latest 3 month data of the max year. based on selection it should show the corresponding 3 month data.</P><P></P><P>i have a month Year field in my data with values&nbsp; like mar-15,feb-15.. etc</P><P></P><P>how can it be achieved?? pls help...</P></BODY></HTML> Thu, 19 Mar 2015 06:14:05 GMT 2015-03-19T06:14:05Z Re: Previous 3 Months Data https://community.qlik.com/t5/QlikView/Re-Previous-3-Months-Data/m-p/746891#M1024905 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need to show in a table only the data for last 3 months. without any selection it should show the latest 3 month data of the max year. based on selection it should show the corresponding 3 month data.</P><P></P><P>i have a month Year field in my data with values&nbsp; like mar-15,feb-15.. etc</P><P></P><P>how can it be achieved?? pls help...</P></BODY></HTML> Thu, 19 Mar 2015 06:14:05 GMT https://community.qlik.com/t5/QlikView/Re-Previous-3-Months-Data/m-p/746891#M1024905 2015-03-19T06:14:05Z Re: Previous 3 Months Data https://community.qlik.com/t5/QlikView/Re-Previous-3-Months-Data/m-p/746892#M1024906 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In your expression</P><P></P><P>try like</P><P>sum({Date={"&gt;=$(=Date(Addmonths(max(Date),-3)))&lt;=$(=Date(max(Date)))"}}Sales)</P><P></P><P>Regards</P></BODY></HTML> Thu, 19 Mar 2015 06:16:30 GMT https://community.qlik.com/t5/QlikView/Re-Previous-3-Months-Data/m-p/746892#M1024906 PrashantSangle 2015-03-19T06:16:30Z