topic Calculate Rolling Average Hours for 30 weeks in QlikView https://community.qlik.com/t5/QlikView/Calculate-Rolling-Average-Hours-for-30-weeks/m-p/41719#M777628 <HTML><HEAD></HEAD><BODY><P>I have the following columns in my data model:</P><P></P><P><IMG alt="Captur2e.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/199731_Captur2e.JPG" style="height: 232px; width: 620px;" /></P><P></P><P>I have to calculate the rolling average of hours a resource has spent on a particular project over last 30 weeks.</P><P></P><P>I found some solutions online but I'm not able to use them for my requirement.</P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Since I have date/month/quarter/year filters in my dashboard, should I be calculating the rolling average at app level or script level?</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Any help will be appreciated!</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Thanks,</SPAN></P><P><SPAN style="font-size: 13.3333px;"><EM><STRONG>YASH</STRONG></EM><BR /></SPAN></P><P><SPAN style="font-size: 10pt;"> </SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT yashcena 2020-11-25T16:16:04Z Calculate Rolling Average Hours for 30 weeks https://community.qlik.com/t5/QlikView/Calculate-Rolling-Average-Hours-for-30-weeks/m-p/41719#M777628 <HTML><HEAD></HEAD><BODY><P>I have the following columns in my data model:</P><P></P><P><IMG alt="Captur2e.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/199731_Captur2e.JPG" style="height: 232px; width: 620px;" /></P><P></P><P>I have to calculate the rolling average of hours a resource has spent on a particular project over last 30 weeks.</P><P></P><P>I found some solutions online but I'm not able to use them for my requirement.</P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Since I have date/month/quarter/year filters in my dashboard, should I be calculating the rolling average at app level or script level?</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Any help will be appreciated!</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Thanks,</SPAN></P><P><SPAN style="font-size: 13.3333px;"><EM><STRONG>YASH</STRONG></EM><BR /></SPAN></P><P><SPAN style="font-size: 10pt;"> </SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Calculate-Rolling-Average-Hours-for-30-weeks/m-p/41719#M777628 yashcena 2020-11-25T16:16:04Z