topic Rolling 12 Mths In Script or Expression? in QlikView https://community.qlik.com/t5/QlikView/Rolling-12-Mths-In-Script-or-Expression/m-p/1321162#M460704 <HTML><HEAD></HEAD><BODY><P>I have data running back around 4 or 5 years.&nbsp; I want to show the rolling 12 month totals for a measure for the last 15 months.&nbsp; I have a pretty standard Calendar Script, and can get this working to a point, however the aggregation is correct for the most recent month but then wrong by increasing measure for each month backwards.</P><P></P><P>I'm trying to replicate the table below from Excel, again suspect will have to use a pivot table, hence cant use Accumulation to my knowledge?</P><P></P><P><IMG alt="QV Query.JPG" class="jive-image image-1" src="/legacyfs/online/160097_QV Query.JPG" style="width: 778px; height: 114px;" /></P></BODY></HTML> Fri, 14 Apr 2017 09:54:06 GMT dmac1971 2017-04-14T09:54:06Z Rolling 12 Mths In Script or Expression? https://community.qlik.com/t5/QlikView/Rolling-12-Mths-In-Script-or-Expression/m-p/1321162#M460704 <HTML><HEAD></HEAD><BODY><P>I have data running back around 4 or 5 years.&nbsp; I want to show the rolling 12 month totals for a measure for the last 15 months.&nbsp; I have a pretty standard Calendar Script, and can get this working to a point, however the aggregation is correct for the most recent month but then wrong by increasing measure for each month backwards.</P><P></P><P>I'm trying to replicate the table below from Excel, again suspect will have to use a pivot table, hence cant use Accumulation to my knowledge?</P><P></P><P><IMG alt="QV Query.JPG" class="jive-image image-1" src="/legacyfs/online/160097_QV Query.JPG" style="width: 778px; height: 114px;" /></P></BODY></HTML> Fri, 14 Apr 2017 09:54:06 GMT https://community.qlik.com/t5/QlikView/Rolling-12-Mths-In-Script-or-Expression/m-p/1321162#M460704 dmac1971 2017-04-14T09:54:06Z Re: Rolling 12 Mths In Script or Expression? https://community.qlik.com/t5/QlikView/Rolling-12-Mths-In-Script-or-Expression/m-p/1321163#M460705 <HTML><HEAD></HEAD><BODY><P>rangesum(before(total sum(yourmeasure)),0,12)</P></BODY></HTML> Fri, 14 Apr 2017 09:58:52 GMT https://community.qlik.com/t5/QlikView/Rolling-12-Mths-In-Script-or-Expression/m-p/1321163#M460705 Anonymous 2017-04-14T09:58:52Z Re: Rolling 12 Mths In Script or Expression? https://community.qlik.com/t5/QlikView/Rolling-12-Mths-In-Script-or-Expression/m-p/1321164#M460706 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/docs/DOC-4252">Calculating rolling n-period totals, averages or other aggregations</A></P></BODY></HTML> Fri, 14 Apr 2017 10:02:24 GMT https://community.qlik.com/t5/QlikView/Rolling-12-Mths-In-Script-or-Expression/m-p/1321164#M460706 MK_QSL 2017-04-14T10:02:24Z Re: Rolling 12 Mths In Script or Expression? https://community.qlik.com/t5/QlikView/Rolling-12-Mths-In-Script-or-Expression/m-p/1321165#M460707 <HTML><HEAD></HEAD><BODY><P>Have skimmed through a number of posts including what you linked and haven't found what I'm looking for.&nbsp; Robin that expression is not returing correct result.</P></BODY></HTML> Fri, 14 Apr 2017 10:05:57 GMT https://community.qlik.com/t5/QlikView/Rolling-12-Mths-In-Script-or-Expression/m-p/1321165#M460707 dmac1971 2017-04-14T10:05:57Z Re: Rolling 12 Mths In Script or Expression? https://community.qlik.com/t5/QlikView/Rolling-12-Mths-In-Script-or-Expression/m-p/1321166#M460708 <HTML><HEAD></HEAD><BODY><P>so please post a small inline example or a sample excel input file...</P></BODY></HTML> Fri, 14 Apr 2017 10:08:57 GMT https://community.qlik.com/t5/QlikView/Rolling-12-Mths-In-Script-or-Expression/m-p/1321166#M460708 Anonymous 2017-04-14T10:08:57Z Re: Rolling 12 Mths In Script or Expression? https://community.qlik.com/t5/QlikView/Rolling-12-Mths-In-Script-or-Expression/m-p/1321167#M460709 <HTML><HEAD></HEAD><BODY><P>If you only provide screenshot, you might not get answer ever after long time. <BR />Provide proper sample data and your expected output.</P><P>We will try to help you out on this.</P></BODY></HTML> Fri, 14 Apr 2017 10:13:54 GMT https://community.qlik.com/t5/QlikView/Rolling-12-Mths-In-Script-or-Expression/m-p/1321167#M460709 MK_QSL 2017-04-14T10:13:54Z Re: Rolling 12 Mths In Script or Expression? https://community.qlik.com/t5/QlikView/Rolling-12-Mths-In-Script-or-Expression/m-p/1321168#M460710 <HTML><HEAD></HEAD><BODY><P>Yes accept that, however its not always possible to share data.&nbsp; Will mock something up to see if I can get across what I am trying to achieve, thanks for your help so far.</P></BODY></HTML> Fri, 14 Apr 2017 11:00:26 GMT https://community.qlik.com/t5/QlikView/Rolling-12-Mths-In-Script-or-Expression/m-p/1321168#M460710 dmac1971 2017-04-14T11:00:26Z Re: Rolling 12 Mths In Script or Expression? https://community.qlik.com/t5/QlikView/Rolling-12-Mths-In-Script-or-Expression/m-p/1321169#M460711 <HTML><HEAD></HEAD><BODY><P>Yes I also accept that its not always possible to share data. But it's always possible to create dummy data accordingly to our applications and share here.</P></BODY></HTML> Fri, 14 Apr 2017 12:22:50 GMT https://community.qlik.com/t5/QlikView/Rolling-12-Mths-In-Script-or-Expression/m-p/1321169#M460711 MK_QSL 2017-04-14T12:22:50Z Re: Rolling 12 Mths In Script or Expression? https://community.qlik.com/t5/QlikView/Rolling-12-Mths-In-Script-or-Expression/m-p/1321170#M460712 <HTML><HEAD></HEAD><BODY><P>no example --&gt; no solution <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 14 Apr 2017 12:39:26 GMT https://community.qlik.com/t5/QlikView/Rolling-12-Mths-In-Script-or-Expression/m-p/1321170#M460712 Anonymous 2017-04-14T12:39:26Z