topic Re: last 30 days sum in QlikView https://community.qlik.com/t5/QlikView/last-30-days-sum/m-p/832098#M292788 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>thanks...</P><P></P><P>Kindly find the attached.for 'Avg. Gross Adds (Last 30 days)' i have to calculate the last 30 days sum.</P><P></P><P>Please suggest</P></BODY></HTML> Mon, 11 May 2015 11:32:54 GMT 2015-05-11T11:32:54Z last 30 days sum https://community.qlik.com/t5/QlikView/last-30-days-sum/m-p/832096#M292786 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>i have a pivot table in tht i am using date as dimension</P><P>so my requirement is i have to show the last 30 days sum(value) for each date.</P><P></P><P>ie. for 1-5-15 , the sum(value) should take from 1-4-15 to 1-5-15</P></BODY></HTML> Mon, 11 May 2015 09:53:11 GMT https://community.qlik.com/t5/QlikView/last-30-days-sum/m-p/832096#M292786 2015-05-11T09:53:11Z Re: last 30 days sum https://community.qlik.com/t5/QlikView/last-30-days-sum/m-p/832097#M292787 <HTML><HEAD></HEAD><BODY><P>This is what is called a rolling n-period, there are numerous posts about this. One that covers several solutions, examples and links to other posts is this one: </P><P></P><P><A href="https://community.qlik.com/docs/DOC-4252">Calculating rolling n-period totals, averages or other aggregations</A></P></BODY></HTML> Mon, 11 May 2015 10:15:08 GMT https://community.qlik.com/t5/QlikView/last-30-days-sum/m-p/832097#M292787 stigchel 2015-05-11T10:15:08Z Re: last 30 days sum https://community.qlik.com/t5/QlikView/last-30-days-sum/m-p/832098#M292788 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>thanks...</P><P></P><P>Kindly find the attached.for 'Avg. Gross Adds (Last 30 days)' i have to calculate the last 30 days sum.</P><P></P><P>Please suggest</P></BODY></HTML> Mon, 11 May 2015 11:32:54 GMT https://community.qlik.com/t5/QlikView/last-30-days-sum/m-p/832098#M292788 2015-05-11T11:32:54Z