topic Re: Need Help?? in QlikView https://community.qlik.com/t5/QlikView/Need-Help/m-p/678218#M1087302 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">sum({&lt;month={'&gt;=$(=monthstart(addmonths(today(),-6)))'}&gt;}Sales)</SPAN></P></BODY></HTML> Fri, 13 Jun 2014 15:25:09 GMT venkatg6759 2014-06-13T15:25:09Z Need Help?? https://community.qlik.com/t5/QlikView/Need-Help/m-p/678217#M1087301 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P>Calculate Sales history by month for last six month.</P><P></P><P>Thanks..</P></BODY></HTML> Fri, 13 Jun 2014 15:22:24 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/678217#M1087301 Nagaraju_KCS 2014-06-13T15:22:24Z Re: Need Help?? https://community.qlik.com/t5/QlikView/Need-Help/m-p/678218#M1087302 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">sum({&lt;month={'&gt;=$(=monthstart(addmonths(today(),-6)))'}&gt;}Sales)</SPAN></P></BODY></HTML> Fri, 13 Jun 2014 15:25:09 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/678218#M1087302 venkatg6759 2014-06-13T15:25:09Z Re: Need Help?? https://community.qlik.com/t5/QlikView/Need-Help/m-p/678219#M1087303 <HTML><HEAD></HEAD><BODY><P>Hi Venkat,</P><P></P><P>it's not working. i want based on current selection.</P><P>suppose if i am click Dec2013,&nbsp; i want to show last 6 months...</P></BODY></HTML> Fri, 13 Jun 2014 15:37:16 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/678219#M1087303 Nagaraju_KCS 2014-06-13T15:37:16Z Re: Need Help?? https://community.qlik.com/t5/QlikView/Need-Help/m-p/678220#M1087304 <HTML><HEAD></HEAD><BODY><P>what is you selection format?</P><P></P><P>It is MMM or MMMYYYY or MMMYY or...???</P></BODY></HTML> Fri, 13 Jun 2014 15:42:06 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/678220#M1087304 MK_QSL 2014-06-13T15:42:06Z Re: Re: Need Help?? https://community.qlik.com/t5/QlikView/Need-Help/m-p/678221#M1087305 <HTML><HEAD></HEAD><BODY><P>Check the sample attachment</P></BODY></HTML> Fri, 13 Jun 2014 15:42:36 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/678221#M1087305 venkatg6759 2014-06-13T15:42:36Z Re: Need Help?? https://community.qlik.com/t5/QlikView/Need-Help/m-p/678222#M1087306 <HTML><HEAD></HEAD><BODY><P>instead of today you can use max(month).</P></BODY></HTML> Fri, 13 Jun 2014 15:58:49 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/678222#M1087306 2014-06-13T15:58:49Z