topic Re: Rolling Averages in QlikView https://community.qlik.com/t5/QlikView/Rolling-Averages/m-p/668772#M1081918 <HTML><HEAD></HEAD><BODY><P>Hi Lior,</P><P></P><P>That certainly gets me going in the right direction for the rolling averages, so thank you.</P><P></P><P>Any idea on how to manage that time-based query for the % usage?</P><P></P><P>Thanks,</P><P>Dan</P></BODY></HTML> Fri, 27 Jun 2014 19:13:06 GMT 2014-06-27T19:13:06Z Rolling Averages https://community.qlik.com/t5/QlikView/Rolling-Averages/m-p/668770#M1081916 <HTML><HEAD></HEAD><BODY><P>Hi folks,</P><P></P><P>I'm fairly new to Qlik and was assigned a few tasks given some usage data of a certain program here at my company.</P><P></P><P>Here's my assignment:</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">1. I would like to show the % of each "role" who have logged in last 7, 14, 21, or 28 days</SPAN></P><P> <SPAN style="font-size: 10pt; line-height: 1.5em;"> </SPAN></P><P>2. And cumulative time per week for a rolling 4 week time frame…so on average for the last 4 weeks how many minutes is an Manager spending logged into this tool.</P><P></P><P>Now, I've gone through and just mocked up some data but the core principles should remain the same (I'm hoping).</P><P>I've attached the qvw I'm working on, and I'll throw in the excel as well.</P><P></P><P>This one has really stumped me so far. I guess my general unfamiliarity with some more advanced functions is not helping my cause!</P><P></P><P>Will very much appreciate any advice! </P><P></P><P>Thanks,</P><P>Dan</P></BODY></HTML> Fri, 27 Jun 2014 15:27:46 GMT https://community.qlik.com/t5/QlikView/Rolling-Averages/m-p/668770#M1081916 2014-06-27T15:27:46Z Re: Rolling Averages https://community.qlik.com/t5/QlikView/Rolling-Averages/m-p/668771#M1081917 <HTML><HEAD></HEAD><BODY><P>This post might help:</P><P><A href="https://community.qlik.com/docs/DOC-4252">Calculating rolling n-period totals, averages or other aggregations</A></P></BODY></HTML> Fri, 27 Jun 2014 16:47:35 GMT https://community.qlik.com/t5/QlikView/Rolling-Averages/m-p/668771#M1081917 2014-06-27T16:47:35Z Re: Rolling Averages https://community.qlik.com/t5/QlikView/Rolling-Averages/m-p/668772#M1081918 <HTML><HEAD></HEAD><BODY><P>Hi Lior,</P><P></P><P>That certainly gets me going in the right direction for the rolling averages, so thank you.</P><P></P><P>Any idea on how to manage that time-based query for the % usage?</P><P></P><P>Thanks,</P><P>Dan</P></BODY></HTML> Fri, 27 Jun 2014 19:13:06 GMT https://community.qlik.com/t5/QlikView/Rolling-Averages/m-p/668772#M1081918 2014-06-27T19:13:06Z