topic Re: PERIOD Display in QlikView https://community.qlik.com/t5/QlikView/PERIOD-Display/m-p/555422#M207442 <HTML><HEAD></HEAD><BODY><P>Do you want the sum of the sales for the previous 3 months?&nbsp; If so, then use rangesum</P><P></P><P>rangesum(below(total sum(sales),1,3))</P></BODY></HTML> Mon, 23 Sep 2013 13:31:42 GMT 2013-09-23T13:31:42Z PERIOD Display https://community.qlik.com/t5/QlikView/PERIOD-Display/m-p/555421#M207441 <HTML><HEAD></HEAD><BODY><P>Hi there, </P><P></P><P>A user asked me to display in one table, SALES for the current month and SALES for the <STRONG>previous</STRONG> THREE months.</P><P>With Dimensions being the "CAR MAKE", "MONTHS" and then one expression "SALES COUNT". I have tried using variables and the AddMonths function etc, but it's not working.</P><P></P><P>How can I achieve this?</P><P></P><P>Regards.</P></BODY></HTML> Mon, 23 Sep 2013 13:22:15 GMT https://community.qlik.com/t5/QlikView/PERIOD-Display/m-p/555421#M207441 2013-09-23T13:22:15Z Re: PERIOD Display https://community.qlik.com/t5/QlikView/PERIOD-Display/m-p/555422#M207442 <HTML><HEAD></HEAD><BODY><P>Do you want the sum of the sales for the previous 3 months?&nbsp; If so, then use rangesum</P><P></P><P>rangesum(below(total sum(sales),1,3))</P></BODY></HTML> Mon, 23 Sep 2013 13:31:42 GMT https://community.qlik.com/t5/QlikView/PERIOD-Display/m-p/555422#M207442 2013-09-23T13:31:42Z Re: PERIOD Display https://community.qlik.com/t5/QlikView/PERIOD-Display/m-p/555423#M207443 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Try like this</P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/docs/DOC-4252">http://community.qlik.com/docs/DOC-4252</A></P></BODY></HTML> Mon, 23 Sep 2013 13:38:25 GMT https://community.qlik.com/t5/QlikView/PERIOD-Display/m-p/555423#M207443 MayilVahanan 2013-09-23T13:38:25Z