topic Last Months Activity in QlikView https://community.qlik.com/t5/QlikView/Last-Months-Activity/m-p/879498#M470740 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I'm trying to write a formula to just bring through last months activity, ive tried using the formula but with no joy.</P><P></P><P>Anyone have any ideas as to how I could alter this to bring through just last months data?</P><P></P><P></P><P style="text-indent: -18pt;"><SPAN lang="EN" style="font-family: Symbol; color: #3d3d3d; font-size: 10pt;"><SPAN class="pasted-list-info">·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =</SPAN></SPAN><SPAN lang="EN" style="font-family: 'Helvetica','sans-serif'; color: #3d3d3d; font-size: 10pt;">SUM({&lt;Metric_Code “RTT9”={"&gt;=$(=MonthStart(Today(),-1)) &lt;=$(=MonthEnd(Today(),-1))"}&gt;} Metric_Value)</SPAN></P><P style="text-indent: -18pt;"><SPAN lang="EN" style="font-family: 'Helvetica','sans-serif'; color: #3d3d3d; font-size: 10pt;"></SPAN> </P><P style="text-indent: -18pt;"><SPAN lang="EN" style="font-family: 'Helvetica','sans-serif'; color: #3d3d3d; font-size: 10pt;"></SPAN> </P><P style="text-indent: -18pt;"><SPAN lang="EN" style="font-family: 'Helvetica','sans-serif'; color: #3d3d3d; font-size: 10pt;">mMany thanks in advance,</SPAN></P><P style="text-indent: -18pt;"><SPAN lang="EN" style="font-family: 'Helvetica','sans-serif'; color: #3d3d3d; font-size: 10pt;"></SPAN> </P><P style="text-indent: -18pt;"><SPAN lang="EN" style="font-family: 'Helvetica','sans-serif'; color: #3d3d3d; font-size: 10pt;">Nick</SPAN></P></BODY></HTML> Tue, 05 May 2015 13:34:30 GMT 2015-05-05T13:34:30Z Last Months Activity https://community.qlik.com/t5/QlikView/Last-Months-Activity/m-p/879498#M470740 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I'm trying to write a formula to just bring through last months activity, ive tried using the formula but with no joy.</P><P></P><P>Anyone have any ideas as to how I could alter this to bring through just last months data?</P><P></P><P></P><P style="text-indent: -18pt;"><SPAN lang="EN" style="font-family: Symbol; color: #3d3d3d; font-size: 10pt;"><SPAN class="pasted-list-info">·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =</SPAN></SPAN><SPAN lang="EN" style="font-family: 'Helvetica','sans-serif'; color: #3d3d3d; font-size: 10pt;">SUM({&lt;Metric_Code “RTT9”={"&gt;=$(=MonthStart(Today(),-1)) &lt;=$(=MonthEnd(Today(),-1))"}&gt;} Metric_Value)</SPAN></P><P style="text-indent: -18pt;"><SPAN lang="EN" style="font-family: 'Helvetica','sans-serif'; color: #3d3d3d; font-size: 10pt;"></SPAN> </P><P style="text-indent: -18pt;"><SPAN lang="EN" style="font-family: 'Helvetica','sans-serif'; color: #3d3d3d; font-size: 10pt;"></SPAN> </P><P style="text-indent: -18pt;"><SPAN lang="EN" style="font-family: 'Helvetica','sans-serif'; color: #3d3d3d; font-size: 10pt;">mMany thanks in advance,</SPAN></P><P style="text-indent: -18pt;"><SPAN lang="EN" style="font-family: 'Helvetica','sans-serif'; color: #3d3d3d; font-size: 10pt;"></SPAN> </P><P style="text-indent: -18pt;"><SPAN lang="EN" style="font-family: 'Helvetica','sans-serif'; color: #3d3d3d; font-size: 10pt;">Nick</SPAN></P></BODY></HTML> Tue, 05 May 2015 13:34:30 GMT https://community.qlik.com/t5/QlikView/Last-Months-Activity/m-p/879498#M470740 2015-05-05T13:34:30Z Re: Last Months Activity https://community.qlik.com/t5/QlikView/Last-Months-Activity/m-p/879499#M470741 <HTML><HEAD></HEAD><BODY><P>Hi Nick,</P><P></P><P>check this one out!</P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/docs/DOC-4313">https://community.qlik.com/docs/DOC-4313</A></P><P></P><P>Andy</P></BODY></HTML> Tue, 05 May 2015 13:47:56 GMT https://community.qlik.com/t5/QlikView/Last-Months-Activity/m-p/879499#M470741 awhitfield 2015-05-05T13:47:56Z