https://community.qlik.com/t5/Suggest-an-Idea/Create-a-Rolling-Period-Function-for-use-in-Expressions/idi-p/1721529 <P>Imagine if you could easily create a Rolling period expression using a Qlik Function i.e.&nbsp;</P> <P>Rolling(Field to Roll On, Number of Periods to Roll, Weighting, Forwards (1) /Backwards (0), Go beyond selection (0)/Restrict to selection (1))</P> <P>e.g. Sum({&lt;Rolling(Months, 3, 0, 0, 0)&gt;}Sales) = Sum Sales rolled backwards on the field Months for 3 periods, no weighting, with results not restricted to date selections. i.e. if dates selected = 2020 Calendar Year, the results for January will include November and December 2019.</P> <P>e.g. avg({&lt;Rolling(Days, 60, 50, 0, 0)&gt;} Incidents) = Average Incidents rolled backwards on the field Days for 60 days with a weighting of the most recent date being 50% more important than the start date, scaled linearly over the rolling period.&nbsp;</P> <P>Benefits:</P> <UL> <LI>Prevent having to create multiple "as if" fields - which means that our apps will be leaner and faster.</LI> <LI>Allows the user to create and compare multiple measures easily e.g. competing moving averages</LI> <LI>Prevents the challenges around only accumulating data selected e.g. if I want to show 12 months rolling, accumulation only accumulates the data selected.</LI> </UL> Wed, 25 Nov 2020 08:56:29 GMT richard_blakemore 2020-11-25T08:56:29Z https://community.qlik.com/t5/Suggest-an-Idea/Create-a-Rolling-Period-Function-for-use-in-Expressions/idc-p/1721543#M2578 <P>Hello&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/30393">@richard_blakemore</a>,</P> <P><SPAN>Thanks for your post. Going forward, please use one, and only one, label per post. Refer to the&nbsp;</SPAN><A href="https://community.qlik.com/t5/Qlik-Product-Insight-Blog/Submitting-an-Idea/ba-p/1684014" target="_self">submission guidelines</A><SPAN>&nbsp;for more details.</SPAN></P> Wed, 24 Jun 2020 05:09:14 GMT https://community.qlik.com/t5/Suggest-an-Idea/Create-a-Rolling-Period-Function-for-use-in-Expressions/idc-p/1721543#M2578 John_Teichman 2020-06-24T05:09:14Z https://community.qlik.com/t5/Suggest-an-Idea/Create-a-Rolling-Period-Function-for-use-in-Expressions/idc-p/1747432#M3603 <P>Great idea!</P><P>That would be awesome if they could implement something like that and have it perform as well or faster than the existing methods.</P> Sun, 27 Sep 2020 02:55:32 GMT https://community.qlik.com/t5/Suggest-an-Idea/Create-a-Rolling-Period-Function-for-use-in-Expressions/idc-p/1747432#M3603 devan9876 2020-09-27T02:55:32Z https://community.qlik.com/t5/Suggest-an-Idea/Create-a-Rolling-Period-Function-for-use-in-Expressions/idc-p/1759841#M4091 <P>Thank you for your feedback on ways to improve our product, if I understand correctly the accumulation modifier released in 2019 November lets you define rolling periods applied on top of your expression as described.</P><P><A href="https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Visualizations/Bar-Chart/bar-chart-example2.htm#anchor-4" target="_blank">https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Visualizations/Bar-Chart/bar-chart-example2.htm#anchor-4</A></P><P>Thanks,<BR />Patric</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 09 Nov 2020 13:07:43 GMT https://community.qlik.com/t5/Suggest-an-Idea/Create-a-Rolling-Period-Function-for-use-in-Expressions/idc-p/1759841#M4091 Patric_Nordstrom 2020-11-09T13:07:43Z