topic Re: Issue with Rolling 12 Months in QlikView https://community.qlik.com/t5/QlikView/Issue-with-Rolling-12-Months/m-p/351038#M130166 <HTML><HEAD></HEAD><BODY><P>Your issue is your inconsistent date formatting.&nbsp; Set analysis respects date formatting so try this:</P><P></P><P>Sum({&lt;MonthYear={"&gt;$(=Date(AddMonths(Max(MonthYear),-12),'MMM-YYYY'))<SPAN style="color: #ff0000;"><STRONG>&lt;=</STRONG></SPAN>$(=Date(AddMonths(Max(MonthYear),0),'MMM-YYYY'))"}&gt;} Attritiioncount)</P><P></P><P>Also, for some reason you can't have a space either side of the red bit!</P><P></P><P>Hope this helps,</P><P></P><P>Jason </P></BODY></HTML> Sun, 15 Jul 2012 08:11:27 GMT Jason_Michaelides 2012-07-15T08:11:27Z Issue with Rolling 12 Months https://community.qlik.com/t5/QlikView/Issue-with-Rolling-12-Months/m-p/351037#M130165 <HTML><HEAD></HEAD><BODY><P>I'm basically trying to show the sum of a measure for rolling 12 months. For some reason the set analysis is not evaluating properly. </P><P></P><P>When i select apr 2012, the graph should display from may 2011 to apr 2012</P><P></P><P>Any help is appreciated. i'm attaching the sample file for the same.</P></BODY></HTML> Sun, 15 Jul 2012 03:54:02 GMT https://community.qlik.com/t5/QlikView/Issue-with-Rolling-12-Months/m-p/351037#M130165 sudhakar_b 2012-07-15T03:54:02Z Re: Issue with Rolling 12 Months https://community.qlik.com/t5/QlikView/Issue-with-Rolling-12-Months/m-p/351038#M130166 <HTML><HEAD></HEAD><BODY><P>Your issue is your inconsistent date formatting.&nbsp; Set analysis respects date formatting so try this:</P><P></P><P>Sum({&lt;MonthYear={"&gt;$(=Date(AddMonths(Max(MonthYear),-12),'MMM-YYYY'))<SPAN style="color: #ff0000;"><STRONG>&lt;=</STRONG></SPAN>$(=Date(AddMonths(Max(MonthYear),0),'MMM-YYYY'))"}&gt;} Attritiioncount)</P><P></P><P>Also, for some reason you can't have a space either side of the red bit!</P><P></P><P>Hope this helps,</P><P></P><P>Jason </P></BODY></HTML> Sun, 15 Jul 2012 08:11:27 GMT https://community.qlik.com/t5/QlikView/Issue-with-Rolling-12-Months/m-p/351038#M130166 Jason_Michaelides 2012-07-15T08:11:27Z Re: Issue with Rolling 12 Months https://community.qlik.com/t5/QlikView/Issue-with-Rolling-12-Months/m-p/351039#M130167 <HTML><HEAD></HEAD><BODY><P>Hi Jason, Thanks... worked like a charm.</P></BODY></HTML> Sun, 15 Jul 2012 08:19:02 GMT https://community.qlik.com/t5/QlikView/Issue-with-Rolling-12-Months/m-p/351039#M130167 sudhakar_b 2012-07-15T08:19:02Z