topic Weekly Moving average in QlikView https://community.qlik.com/t5/QlikView/Weekly-Moving-average/m-p/515486#M192476 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>I am trying to calculate weekly moving average but not been able to get it right. I have attached the spreadhseet with my data. My requirement is,</P><P>1) Calculate weekly moving average of avg(CYCLE_LENGTH) over next 26 weeks on every Mondays(PROD_DATE). NOTE : PROD_DATE has multiple recs for the same day and multiple recs within the same week. This needs to be aggregated to weekstart MONDAY.</P><P></P><P>Below is the snapshot of the data .</P><P></P><P>Your help is highly appreciated . Kind Regards...CM</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 435px;"><TBODY><TR><TD class="xl65" height="17" width="113">CYCLE_LENGTH</TD><BR /><TD class="xl65" width="72">ITEM</TD><BR /><TD class="xl65" width="64">LOC</TD><BR /><TD class="xl65" width="77">OBS_ID</TD><BR /><TD class="xl65" width="109">PROD_DATE</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">13</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">1</TD><BR /><TD align="right" class="xl67">6/2/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">2</TD><BR /><TD align="right" class="xl67">6/15/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">3</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">3</TD><BR /><TD align="right" class="xl67">6/15/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">4</TD><BR /><TD align="right" class="xl67">6/18/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">5</TD><BR /><TD align="right" class="xl67">6/18/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">6</TD><BR /><TD align="right" class="xl67">6/18/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">7</TD><BR /><TD align="right" class="xl67">6/18/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">8</TD><BR /><TD align="right" class="xl67">6/19/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">9</TD><BR /><TD align="right" class="xl67">6/19/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">10</TD><BR /><TD align="right" class="xl67">6/19/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">11</TD><BR /><TD align="right" class="xl67">6/19/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">12</TD><BR /><TD align="right" class="xl67">6/20/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">2</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">13</TD><BR /><TD align="right" class="xl67">6/20/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">14</TD><BR /><TD align="right" class="xl67">6/22/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">15</TD><BR /><TD align="right" class="xl67">6/22/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">2</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">16</TD><BR /><TD align="right" class="xl67">6/23/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">3</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">17</TD><BR /><TD align="right" class="xl67">6/25/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">18</TD><BR /><TD align="right" class="xl67">6/28/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">19</TD><BR /><TD align="right" class="xl67">6/29/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">3</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">20</TD><BR /><TD align="right" class="xl67">6/29/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">21</TD><BR /><TD align="right" class="xl67">7/2/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">22</TD><BR /><TD align="right" class="xl67">7/2/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">23</TD><BR /><TD align="right" class="xl67">7/2/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">2</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">24</TD><BR /><TD align="right" class="xl67">7/3/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">25</TD><BR /><TD align="right" class="xl67">7/5/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">2</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">26</TD><BR /><TD align="right" class="xl67">7/5/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">27</TD><BR /><TD align="right" class="xl67">7/7/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">2</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">28</TD><BR /><TD align="right" class="xl67">7/7/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">29</TD><BR /><TD align="right" class="xl67">7/9/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">30</TD><BR /><TD align="right" class="xl67">7/10/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">31</TD><BR /><TD align="right" class="xl67">7/10/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">2</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">32</TD><BR /><TD align="right" class="xl67">7/11/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">33</TD><BR /><TD align="right" class="xl67">7/13/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">2</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">34</TD><BR /><TD align="right" class="xl67">7/14/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">35</TD><BR /><TD align="right" class="xl67">7/16/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">36</TD><BR /><TD align="right" class="xl67">7/17/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">37</TD><BR /><TD align="right" class="xl67">7/18/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">38</TD><BR /><TD align="right" class="xl67">7/18/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">39</TD><BR /><TD align="right" class="xl67">7/18/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">2</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">40</TD><BR /><TD align="right" class="xl67">7/19/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">2</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">41</TD><BR /><TD align="right" class="xl67">7/21/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">42</TD><BR /><TD align="right" class="xl67">7/23/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">2</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">43</TD><BR /><TD align="right" class="xl67">7/24/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">44</TD><BR /><TD align="right" class="xl67">7/26/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">2</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">45</TD><BR /><TD align="right" class="xl67">7/26/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">2</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">46</TD><BR /><TD align="right" class="xl67">7/28/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">3</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">47</TD><BR /><TD align="right" class="xl67">7/30/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">48</TD><BR /><TD align="right" class="xl67">8/2/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">11</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">49</TD><BR /><TD align="right" class="xl67">8/3/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">21</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">50</TD><BR /><TD align="right" class="xl67">8/14/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">51</TD><BR /><TD align="right" class="xl67">9/4/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">7</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">52</TD><BR /><TD align="right" class="xl67">9/5/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">53</TD><BR /><TD align="right" class="xl67">9/12/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">6</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">54</TD><BR /><TD align="right" class="xl67">9/13/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">55</TD><BR /><TD align="right" class="xl67">9/19/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">56</TD><BR /><TD align="right" class="xl67">9/20/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">8</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">57</TD><BR /><TD align="right" class="xl67">9/20/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">58</TD><BR /><TD align="right" class="xl67">9/28/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">3</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">59</TD><BR /><TD align="right" class="xl67">9/28/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">2</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">60</TD><BR /><TD align="right" class="xl67">10/1/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">5</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">61</TD><BR /><TD align="right" class="xl67">10/3/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">62</TD><BR /><TD align="right" class="xl67">10/8/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">63</TD><BR /><TD align="right" class="xl67">10/9/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">64</TD><BR /><TD align="right" class="xl67">10/10/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">65</TD><BR /><TD align="right" class="xl67">10/11/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">66</TD><BR /><TD align="right" class="xl67">10/11/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">4</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">67</TD><BR /><TD align="right" class="xl67">10/12/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">68</TD><BR /><TD align="right" class="xl67">10/16/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">69</TD><BR /><TD align="right" class="xl67">10/17/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">70</TD><BR /><TD align="right" class="xl67">10/18/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">71</TD><BR /><TD align="right" class="xl67">10/19/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">72</TD><BR /><TD align="right" class="xl67">10/19/2012</TD><BR /></TR></TBODY></TABLE></BODY></HTML> Tue, 23 Jul 2013 21:43:48 GMT 2013-07-23T21:43:48Z Weekly Moving average https://community.qlik.com/t5/QlikView/Weekly-Moving-average/m-p/515486#M192476 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>I am trying to calculate weekly moving average but not been able to get it right. I have attached the spreadhseet with my data. My requirement is,</P><P>1) Calculate weekly moving average of avg(CYCLE_LENGTH) over next 26 weeks on every Mondays(PROD_DATE). NOTE : PROD_DATE has multiple recs for the same day and multiple recs within the same week. This needs to be aggregated to weekstart MONDAY.</P><P></P><P>Below is the snapshot of the data .</P><P></P><P>Your help is highly appreciated . Kind Regards...CM</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 435px;"><TBODY><TR><TD class="xl65" height="17" width="113">CYCLE_LENGTH</TD><BR /><TD class="xl65" width="72">ITEM</TD><BR /><TD class="xl65" width="64">LOC</TD><BR /><TD class="xl65" width="77">OBS_ID</TD><BR /><TD class="xl65" width="109">PROD_DATE</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">13</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">1</TD><BR /><TD align="right" class="xl67">6/2/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">2</TD><BR /><TD align="right" class="xl67">6/15/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">3</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">3</TD><BR /><TD align="right" class="xl67">6/15/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">4</TD><BR /><TD align="right" class="xl67">6/18/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">5</TD><BR /><TD align="right" class="xl67">6/18/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">6</TD><BR /><TD align="right" class="xl67">6/18/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">7</TD><BR /><TD align="right" class="xl67">6/18/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">8</TD><BR /><TD align="right" class="xl67">6/19/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">9</TD><BR /><TD align="right" class="xl67">6/19/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">10</TD><BR /><TD align="right" class="xl67">6/19/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">11</TD><BR /><TD align="right" class="xl67">6/19/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">12</TD><BR /><TD align="right" class="xl67">6/20/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">2</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">13</TD><BR /><TD align="right" class="xl67">6/20/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">14</TD><BR /><TD align="right" class="xl67">6/22/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">15</TD><BR /><TD align="right" class="xl67">6/22/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">2</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">16</TD><BR /><TD align="right" class="xl67">6/23/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">3</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">17</TD><BR /><TD align="right" class="xl67">6/25/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">18</TD><BR /><TD align="right" class="xl67">6/28/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">19</TD><BR /><TD align="right" class="xl67">6/29/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">3</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">20</TD><BR /><TD align="right" class="xl67">6/29/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">21</TD><BR /><TD align="right" class="xl67">7/2/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">22</TD><BR /><TD align="right" class="xl67">7/2/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">23</TD><BR /><TD align="right" class="xl67">7/2/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">2</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">24</TD><BR /><TD align="right" class="xl67">7/3/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">25</TD><BR /><TD align="right" class="xl67">7/5/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">2</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">26</TD><BR /><TD align="right" class="xl67">7/5/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">27</TD><BR /><TD align="right" class="xl67">7/7/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">2</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">28</TD><BR /><TD align="right" class="xl67">7/7/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">29</TD><BR /><TD align="right" class="xl67">7/9/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">30</TD><BR /><TD align="right" class="xl67">7/10/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">31</TD><BR /><TD align="right" class="xl67">7/10/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">2</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">32</TD><BR /><TD align="right" class="xl67">7/11/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">33</TD><BR /><TD align="right" class="xl67">7/13/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">2</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">34</TD><BR /><TD align="right" class="xl67">7/14/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">35</TD><BR /><TD align="right" class="xl67">7/16/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">36</TD><BR /><TD align="right" class="xl67">7/17/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">37</TD><BR /><TD align="right" class="xl67">7/18/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">38</TD><BR /><TD align="right" class="xl67">7/18/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">39</TD><BR /><TD align="right" class="xl67">7/18/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">2</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">40</TD><BR /><TD align="right" class="xl67">7/19/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">2</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">41</TD><BR /><TD align="right" class="xl67">7/21/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">42</TD><BR /><TD align="right" class="xl67">7/23/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">2</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">43</TD><BR /><TD align="right" class="xl67">7/24/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">44</TD><BR /><TD align="right" class="xl67">7/26/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">2</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">45</TD><BR /><TD align="right" class="xl67">7/26/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">2</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">46</TD><BR /><TD align="right" class="xl67">7/28/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">3</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">47</TD><BR /><TD align="right" class="xl67">7/30/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">48</TD><BR /><TD align="right" class="xl67">8/2/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">11</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">49</TD><BR /><TD align="right" class="xl67">8/3/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">21</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">50</TD><BR /><TD align="right" class="xl67">8/14/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">51</TD><BR /><TD align="right" class="xl67">9/4/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">7</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">52</TD><BR /><TD align="right" class="xl67">9/5/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">53</TD><BR /><TD align="right" class="xl67">9/12/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">6</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">54</TD><BR /><TD align="right" class="xl67">9/13/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">55</TD><BR /><TD align="right" class="xl67">9/19/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">56</TD><BR /><TD align="right" class="xl67">9/20/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">8</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">57</TD><BR /><TD align="right" class="xl67">9/20/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">58</TD><BR /><TD align="right" class="xl67">9/28/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">3</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">59</TD><BR /><TD align="right" class="xl67">9/28/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">2</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">60</TD><BR /><TD align="right" class="xl67">10/1/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">5</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">61</TD><BR /><TD align="right" class="xl67">10/3/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">62</TD><BR /><TD align="right" class="xl67">10/8/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">63</TD><BR /><TD align="right" class="xl67">10/9/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">64</TD><BR /><TD align="right" class="xl67">10/10/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">65</TD><BR /><TD align="right" class="xl67">10/11/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">66</TD><BR /><TD align="right" class="xl67">10/11/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">4</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">67</TD><BR /><TD align="right" class="xl67">10/12/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">68</TD><BR /><TD align="right" class="xl67">10/16/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">69</TD><BR /><TD align="right" class="xl67">10/17/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">70</TD><BR /><TD align="right" class="xl67">10/18/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">71</TD><BR /><TD align="right" class="xl67">10/19/2012</TD><BR /></TR><BR /><TR><BR /><TD align="right" class="xl66" height="17">1</TD><BR /><TD align="right" class="xl66">5153321</TD><BR /><TD class="xl66">W21P</TD><BR /><TD align="right" class="xl66">72</TD><BR /><TD align="right" class="xl67">10/19/2012</TD><BR /></TR></TBODY></TABLE></BODY></HTML> Tue, 23 Jul 2013 21:43:48 GMT https://community.qlik.com/t5/QlikView/Weekly-Moving-average/m-p/515486#M192476 2013-07-23T21:43:48Z