topic Re: Rolling 30 days Average in script for each date in QlikView https://community.qlik.com/t5/QlikView/Rolling-30-days-Average-in-script-for-each-date/m-p/1428656#M429985 <HTML><HEAD></HEAD><BODY><P>what if there is just 2 Previous day?</P></BODY></HTML> Wed, 11 Oct 2017 10:56:57 GMT Kushal_Chawda 2017-10-11T10:56:57Z Rolling 30 days Average in script for each date https://community.qlik.com/t5/QlikView/Rolling-30-days-Average-in-script-for-each-date/m-p/1428652#M429981 <HTML><HEAD></HEAD><BODY><P>Hi Team,</P><P></P><P>I would like to calculate the Rolling 3 days average in Qlikview script based upon the File date.</P><P></P><P>If we take it the File Date - 01/05/2017, it should calculate the average of last 3 days like as sum(684,458,235)/3 =459</P><P></P><P>Here is My data set.</P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" height="503" style="width: 177px; height: 515px;"><TBODY><TR><TD height="20" width="73">File Date</TD><TD width="64">Size</TD></TR><TR><TD align="right" class="xl63" height="20">01-01-2017</TD><TD align="right">121</TD></TR><TR><TD align="right" class="xl63" height="20">01-02-2017</TD><TD align="right">235</TD></TR><TR><TD align="right" class="xl63" height="20">01-03-2017</TD><TD align="right">458</TD></TR><TR><TD align="right" class="xl63" height="20">01-04-2017</TD><TD align="right">684</TD></TR><TR><TD align="right" class="xl63" height="20">01-05-2017</TD><TD align="right">453</TD></TR><TR><TD align="right" class="xl63" height="20">01-06-2017</TD><TD align="right">159</TD></TR><TR><TD align="right" class="xl63" height="20">01-07-2017</TD><TD align="right">147</TD></TR><TR><TD align="right" class="xl63" height="20">01-08-2017</TD><TD align="right">596</TD></TR><TR><TD align="right" class="xl63" height="20">01-09-2017</TD><TD align="right">999</TD></TR><TR><TD align="right" class="xl63" height="20">01-10-2017</TD><TD align="right">100</TD></TR><TR><TD align="right" class="xl63" height="20">01-11-2017</TD><TD align="right">158</TD></TR></TBODY></TABLE><P></P><P>Please let me know if you have suggestions.</P><P></P><P>Regards, </P><P>Shakila D </P></BODY></HTML> Tue, 10 Oct 2017 18:54:28 GMT https://community.qlik.com/t5/QlikView/Rolling-30-days-Average-in-script-for-each-date/m-p/1428652#M429981 Anonymous 2017-10-10T18:54:28Z Re: Rolling 30 days Average in script for each date https://community.qlik.com/t5/QlikView/Rolling-30-days-Average-in-script-for-each-date/m-p/1428653#M429982 <HTML><HEAD></HEAD><BODY><P>In your chart syntax, you can try with :</P><P></P><P>RangeAvg(Below(Size,-1,3))</P><P></P><P>I can't manage to use Below() in script but <SPAN class="short_text" lang="en"><SPAN>apparently this function works in script.</SPAN></SPAN></P></BODY></HTML> Tue, 10 Oct 2017 19:08:13 GMT https://community.qlik.com/t5/QlikView/Rolling-30-days-Average-in-script-for-each-date/m-p/1428653#M429982 sergio0592 2017-10-10T19:08:13Z Re: Rolling 30 days Average in script for each date https://community.qlik.com/t5/QlikView/Rolling-30-days-Average-in-script-for-each-date/m-p/1428654#M429983 <HTML><HEAD></HEAD><BODY><P>Yes, I have to implement this logic in script. Is any other way to implement?</P></BODY></HTML> Tue, 10 Oct 2017 21:24:45 GMT https://community.qlik.com/t5/QlikView/Rolling-30-days-Average-in-script-for-each-date/m-p/1428654#M429983 Anonymous 2017-10-10T21:24:45Z Re: Rolling 30 days Average in script for each date https://community.qlik.com/t5/QlikView/Rolling-30-days-Average-in-script-for-each-date/m-p/1428655#M429984 <HTML><HEAD></HEAD><BODY><P>Why are you looking another way? </P></BODY></HTML> Wed, 11 Oct 2017 10:06:27 GMT https://community.qlik.com/t5/QlikView/Rolling-30-days-Average-in-script-for-each-date/m-p/1428655#M429984 Anil_Babu_Samineni 2017-10-11T10:06:27Z Re: Rolling 30 days Average in script for each date https://community.qlik.com/t5/QlikView/Rolling-30-days-Average-in-script-for-each-date/m-p/1428656#M429985 <HTML><HEAD></HEAD><BODY><P>what if there is just 2 Previous day?</P></BODY></HTML> Wed, 11 Oct 2017 10:56:57 GMT https://community.qlik.com/t5/QlikView/Rolling-30-days-Average-in-script-for-each-date/m-p/1428656#M429985 Kushal_Chawda 2017-10-11T10:56:57Z Re: Rolling 30 days Average in script for each date https://community.qlik.com/t5/QlikView/Rolling-30-days-Average-in-script-for-each-date/m-p/1428657#M429986 <HTML><HEAD></HEAD><BODY><P>Maybe something like the below</P><P></P><P>a:<BR />LOAD *&nbsp; INLINE [&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp; FileDate, Size<BR />&nbsp;&nbsp;&nbsp; 01/01/2017, 121<BR />&nbsp;&nbsp;&nbsp; 01/02/2017, 235<BR />&nbsp;&nbsp;&nbsp; 01/03/2017, 458<BR />&nbsp;&nbsp;&nbsp; 01/04/2017, 684<BR />&nbsp;&nbsp;&nbsp; 01/05/2017, 453<BR />&nbsp;&nbsp;&nbsp; 01/06/2017, 159<BR />&nbsp;&nbsp;&nbsp; 01/07/2017, 147<BR />&nbsp;&nbsp;&nbsp; 01/08/2017, 596<BR />&nbsp;&nbsp;&nbsp; 01/09/2017, 999<BR />&nbsp;&nbsp;&nbsp; 01/10/2017, 100<BR />&nbsp;&nbsp;&nbsp; 01/11/2017, 158<BR />];</P><P><BR />for i = 1 to 3</P><P>load</P><P>FileDate as FileDate1 ,</P><P>date(FileDate-$(i)) as FileDate</P><P>Resident a ;</P><P>NEXT</P><P></P><P>And use the Filedate1 in the chart to do the average calucaltion</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/179552_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Fri, 13 Oct 2017 11:53:03 GMT https://community.qlik.com/t5/QlikView/Rolling-30-days-Average-in-script-for-each-date/m-p/1428657#M429986 qliksus 2017-10-13T11:53:03Z Re: Rolling 30 days Average in script for each date https://community.qlik.com/t5/QlikView/Rolling-30-days-Average-in-script-for-each-date/m-p/1428658#M429987 <HTML><HEAD></HEAD><BODY><P>Hi Shakila,</P><P></P><P>Try:</P><P></P><P>Data:</P><P>Load</P><P>[File Date],</P><P>Size,</P><P>Rangesum(Size,Peek(Size),Peek(Size,-2)) as AccSize;</P><P>LOAD * INLINE [</P><P>&nbsp;&nbsp;&nbsp; File Date, Size</P><P>&nbsp;&nbsp;&nbsp; 01-01-2017, 121</P><P>&nbsp;&nbsp;&nbsp; 01-02-2017, 235</P><P>&nbsp;&nbsp;&nbsp; 01-03-2017, 458</P><P>&nbsp;&nbsp;&nbsp; 01-04-2017, 684</P><P>&nbsp;&nbsp;&nbsp; 01-05-2017, 453</P><P>&nbsp;&nbsp;&nbsp; 01-06-2017, 159</P><P>&nbsp;&nbsp;&nbsp; 01-07-2017, 147</P><P>&nbsp;&nbsp;&nbsp; 01-08-2017, 596</P><P>&nbsp;&nbsp;&nbsp; 01-09-2017, 999</P><P>&nbsp;&nbsp;&nbsp; 01-10-2017, 100</P><P>&nbsp;&nbsp;&nbsp; 01-11-2017, 158</P><P>];</P><P></P><P>giving:</P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>File Date</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Size</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>AccSize</STRONG></SPAN><STRONG> </STRONG></TH></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01-01-2017</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">121</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">121</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01-02-2017</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">235</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">356</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01-03-2017</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">458</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">814</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01-04-2017</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">684</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1377</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01-05-2017</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">453</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1595</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01-06-2017</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">159</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1296</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01-07-2017</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">147</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">759</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01-08-2017</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">596</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">902</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01-09-2017</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">999</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1742</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01-10-2017</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">100</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1695</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01-11-2017</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">158</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1257</SPAN></TD></TR></TBODY></TABLE><P></P><P>Regards</P><P></P><P>Andrew</P></BODY></HTML> Fri, 13 Oct 2017 12:12:25 GMT https://community.qlik.com/t5/QlikView/Rolling-30-days-Average-in-script-for-each-date/m-p/1428658#M429987 effinty2112 2017-10-13T12:12:25Z