topic Rolling Average Calculation in QlikView

topic Rolling Average Calculation in QlikView https://community.qlik.com/t5/QlikView/Rolling-Average-Calculation/m-p/1206313#M387663 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 816px;"><TBODY><TR><TD colspan="4" height="20" width="351">I have build a QVD with 2 years of data in date lavel and now <SPAN style="font-size: 13.3333px;">wanted to build a logic like this</SPAN></TD></TR><TR><TD class="xl63" colspan="7" height="20">The formula should be Sum(Txn current date)/Average(last 14 days excluding current date) – 1</TD></TR><TR><TD class="xl63" colspan="7" height="20"></TD></TR><TR><TD class="xl64" height="20">Example:</TD></TR><TR><TD class="xl64" colspan="6" height="20">10/3/2016 Txn should be compared to average of Txn from (10/2/2016 – 09/19/2016)</TD></TR><TR><TD class="xl64" colspan="7" height="20">10/2/2016 <SPAN style="font-size: 13.3333px;">Txn </SPAN>should be compared to average of <SPAN style="font-size: 13.3333px;">Txn </SPAN>from (10/1/2016 – 09/18/2016)</TD></TR><TR><TD class="xl64" colspan="7" height="20">10/1/2016 <SPAN style="font-size: 13.3333px;">Txn </SPAN>should be compared to average of <SPAN style="font-size: 13.3333px;">Txn </SPAN>from (09/30/2016 – 09/17/2016)</TD></TR></TBODY></TABLE><P></P><P>Sample Data:</P><P></P><P>     </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 2795px;"><TBODY><TR><TD height="20" width="108">Txn</TD><TD align="right" class="xl65" width="81">10/15/2016</TD><TD align="right" class="xl65" width="81">10/14/2016</TD><TD align="right" class="xl65" width="81">10/13/2016</TD><TD align="right" class="xl65" width="81">10/12/2016</TD><TD align="right" class="xl65" width="81">10/11/2016</TD><TD align="right" class="xl65" width="81">10/10/2016</TD><TD align="right" class="xl65" width="74">10/9/2016</TD><TD align="right" class="xl65" width="74">10/8/2016</TD><TD align="right" class="xl65" width="74">10/7/2016</TD><TD align="right" class="xl65" width="74">10/6/2016</TD><TD align="right" class="xl65" width="74">10/5/2016</TD><TD align="right" class="xl65" width="74">10/4/2016</TD><TD align="right" class="xl65" width="74">10/3/2016</TD><TD align="right" class="xl65" width="74">10/2/2016</TD><TD align="right" class="xl65" width="74">10/1/2016</TD><TD align="right" class="xl65" width="74">9/30/2016</TD><TD align="right" class="xl65" width="74">9/29/2016</TD><TD align="right" class="xl65" width="74">9/28/2016</TD><TD align="right" class="xl65" width="74">9/27/2016</TD><TD align="right" class="xl65" width="74">9/26/2016</TD><TD align="right" class="xl65" width="74">9/25/2016</TD><TD align="right" class="xl65" width="74">9/24/2016</TD><TD align="right" class="xl65" width="74">9/23/2016</TD><TD align="right" class="xl65" width="74">9/22/2016</TD><TD align="right" class="xl65" width="74">9/21/2016</TD><TD align="right" class="xl65" width="75">9/20/2016</TD><TD align="right" class="xl65" width="72">9/19/2016</TD><TD align="right" class="xl65" width="72">9/18/2016</TD><TD align="right" class="xl65" width="72">9/17/2016</TD><TD align="right" class="xl65" width="72">9/16/2016</TD><TD align="right" class="xl65" width="72">9/15/2016</TD><TD align="right" class="xl65" width="72">9/14/2016</TD><TD align="right" class="xl65" width="72">9/13/2016</TD><TD align="right" class="xl65" width="72">9/12/2016</TD><TD align="right" class="xl65" width="72">9/11/2016</TD><TD align="right" class="xl65" width="72">9/10/2016</TD></TR><TR><TD height="20">Partner A</TD><TD align="right">100</TD><TD align="right">101</TD><TD align="right">102</TD><TD align="right">103</TD><TD align="right">104</TD><TD align="right">105</TD><TD align="right">106</TD><TD align="right">107</TD><TD align="right">108</TD><TD align="right">109</TD><TD align="right">110</TD><TD align="right">111</TD><TD align="right">112</TD><TD align="right">113</TD><TD align="right">114</TD><TD align="right">115</TD><TD align="right">116</TD><TD align="right">117</TD><TD align="right">118</TD><TD align="right">119</TD><TD align="right">120</TD><TD align="right">121</TD><TD align="right">122</TD><TD align="right">123</TD><TD align="right">124</TD><TD align="right">125</TD><TD align="right">126</TD><TD align="right">127</TD><TD align="right">128</TD><TD align="right">129</TD><TD align="right">130</TD><TD align="right">131</TD><TD align="right">132</TD><TD align="right">133</TD><TD align="right">134</TD><TD align="right">135</TD></TR><TR><TD height="20">Partner B</TD><TD align="right">276</TD><TD align="right">277</TD><TD align="right">278</TD><TD align="right">279</TD><TD align="right">280</TD><TD align="right">281</TD><TD align="right">282</TD><TD align="right">283</TD><TD align="right">284</TD><TD align="right">285</TD><TD align="right">286</TD><TD align="right">287</TD><TD align="right">288</TD><TD align="right">289</TD><TD align="right">290</TD><TD align="right">291</TD><TD align="right">292</TD><TD align="right">293</TD><TD align="right">294</TD><TD align="right">295</TD><TD align="right">296</TD><TD align="right">297</TD><TD align="right">298</TD><TD align="right">299</TD><TD align="right">300</TD><TD align="right">301</TD><TD align="right">302</TD><TD align="right">303</TD><TD align="right">304</TD><TD align="right">305</TD><TD align="right">306</TD><TD align="right">307</TD><TD align="right">308</TD><TD align="right">309</TD><TD align="right">310</TD><TD align="right">311</TD></TR><TR><TD height="20">Partner C</TD><TD align="right">50</TD><TD align="right">51</TD><TD align="right">52</TD><TD align="right">53</TD><TD align="right">54</TD><TD align="right">55</TD><TD align="right">56</TD><TD align="right">57</TD><TD align="right">58</TD><TD align="right">59</TD><TD align="right">60</TD><TD align="right">61</TD><TD align="right">62</TD><TD align="right">63</TD><TD align="right">64</TD><TD align="right">65</TD><TD align="right">66</TD><TD align="right">67</TD><TD align="right">68</TD><TD align="right">69</TD><TD align="right">70</TD><TD align="right">71</TD><TD align="right">72</TD><TD align="right">73</TD><TD align="right">74</TD><TD align="right">75</TD><TD align="right">76</TD><TD align="right">77</TD><TD align="right">78</TD><TD align="right">79</TD><TD align="right">80</TD><TD align="right">81</TD><TD align="right">82</TD><TD align="right">83</TD><TD align="right">84</TD><TD align="right">85</TD></TR><TR><TD height="20">Partner D</TD><TD align="right">177</TD><TD align="right">178</TD><TD align="right">179</TD><TD align="right">180</TD><TD align="right">181</TD><TD align="right">182</TD><TD align="right">183</TD><TD align="right">184</TD><TD align="right">185</TD><TD align="right">186</TD><TD align="right">187</TD><TD align="right">188</TD><TD align="right">189</TD><TD align="right">190</TD><TD align="right">191</TD><TD align="right">192</TD><TD align="right">193</TD><TD align="right">194</TD><TD align="right">195</TD><TD align="right">196</TD><TD align="right">197</TD><TD align="right">198</TD><TD align="right">199</TD><TD align="right">200</TD><TD align="right">201</TD><TD align="right">202</TD><TD align="right">203</TD><TD align="right">204</TD><TD align="right">205</TD><TD align="right">206</TD><TD align="right">207</TD><TD align="right">208</TD><TD align="right">209</TD><TD align="right">210</TD><TD align="right">211</TD><TD align="right">212</TD></TR></TBODY></TABLE><P></P><P></P><P>Required output:</P><P>   </P><TABLE border="0" cellpadding="0" cellspacing="0" width="1260"><TBODY><TR><TD class="xl69" colspan="4" height="20" width="351">Result Set (will always display latest 15 days)</TD></TR><TR><TD class="xl65" height="20">Date -></TD><TD align="right" class="xl66" style="border-left: none;">10/15/2016</TD><TD align="right" class="xl66" style="border-left: none;">10/14/2016</TD><TD align="right" class="xl66" style="border-left: none;">10/13/2016</TD><TD align="right" class="xl66" style="border-left: none;">10/12/2016</TD><TD align="right" class="xl66" style="border-left: none;">10/11/2016</TD><TD align="right" class="xl66" style="border-left: none;">10/10/2016</TD><TD align="right" class="xl66" style="border-left: none;">10/9/2016</TD><TD align="right" class="xl66" style="border-left: none;">10/8/2016</TD><TD align="right" class="xl66" style="border-left: none;">10/7/2016</TD><TD align="right" class="xl66" style="border-left: none;">10/6/2016</TD><TD align="right" class="xl66" style="border-left: none;">10/5/2016</TD><TD align="right" class="xl66" style="border-left: none;">10/4/2016</TD><TD align="right" class="xl66" style="border-left: none;">10/3/2016</TD><TD align="right" class="xl66" style="border-left: none;">10/2/2016</TD><TD align="right" class="xl66" style="border-left: none;">10/1/2016</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Partner A</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">93.0%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">93.1%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">93.2%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">93.2%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">93.3%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">93.3%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">93.4%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">93.4%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">93.5%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">93.6%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">93.6%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">93.7%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">93.7%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">93.8%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">93.8%</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Partner B</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">97.4%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">97.4%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">97.4%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">97.4%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">97.4%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">97.4%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">97.4%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">97.4%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">97.4%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">97.4%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">97.4%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">97.5%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">97.5%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">97.5%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">97.5%</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Partner C</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">87.0%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">87.2%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">87.4%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">87.6%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">87.8%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">88.0%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">88.2%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">88.4%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">88.5%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">88.7%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">88.9%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">89.1%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">89.2%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">89.4%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">89.5%</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Partner D</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">95.9%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">96.0%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">96.0%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">96.0%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">96.0%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">96.0%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">96.1%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">96.1%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">96.1%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">96.1%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">96.1%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">96.2%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">96.2%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">96.2%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">96.2%</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 19 Oct 2016 19:22:06 GMT 2016-10-19T19:22:06Z Rolling Average Calculation https://community.qlik.com/t5/QlikView/Rolling-Average-Calculation/m-p/1206313#M387663 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 816px;"><TBODY><TR><TD colspan="4" height="20" width="351">I have build a QVD with 2 years of data in date lavel and now <SPAN style="font-size: 13.3333px;">wanted to build a logic like this</SPAN></TD></TR><TR><TD class="xl63" colspan="7" height="20">The formula should be Sum(Txn current date)/Average(last 14 days excluding current date) – 1</TD></TR><TR><TD class="xl63" colspan="7" height="20"></TD></TR><TR><TD class="xl64" height="20">Example:</TD></TR><TR><TD class="xl64" colspan="6" height="20">10/3/2016 Txn should be compared to average of Txn from (10/2/2016 – 09/19/2016)</TD></TR><TR><TD class="xl64" colspan="7" height="20">10/2/2016 <SPAN style="font-size: 13.3333px;">Txn </SPAN>should be compared to average of <SPAN style="font-size: 13.3333px;">Txn </SPAN>from (10/1/2016 – 09/18/2016)</TD></TR><TR><TD class="xl64" colspan="7" height="20">10/1/2016 <SPAN style="font-size: 13.3333px;">Txn </SPAN>should be compared to average of <SPAN style="font-size: 13.3333px;">Txn </SPAN>from (09/30/2016 – 09/17/2016)</TD></TR></TBODY></TABLE><P></P><P>Sample Data:</P><P></P><P>     </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 2795px;"><TBODY><TR><TD height="20" width="108">Txn</TD><TD align="right" class="xl65" width="81">10/15/2016</TD><TD align="right" class="xl65" width="81">10/14/2016</TD><TD align="right" class="xl65" width="81">10/13/2016</TD><TD align="right" class="xl65" width="81">10/12/2016</TD><TD align="right" class="xl65" width="81">10/11/2016</TD><TD align="right" class="xl65" width="81">10/10/2016</TD><TD align="right" class="xl65" width="74">10/9/2016</TD><TD align="right" class="xl65" width="74">10/8/2016</TD><TD align="right" class="xl65" width="74">10/7/2016</TD><TD align="right" class="xl65" width="74">10/6/2016</TD><TD align="right" class="xl65" width="74">10/5/2016</TD><TD align="right" class="xl65" width="74">10/4/2016</TD><TD align="right" class="xl65" width="74">10/3/2016</TD><TD align="right" class="xl65" width="74">10/2/2016</TD><TD align="right" class="xl65" width="74">10/1/2016</TD><TD align="right" class="xl65" width="74">9/30/2016</TD><TD align="right" class="xl65" width="74">9/29/2016</TD><TD align="right" class="xl65" width="74">9/28/2016</TD><TD align="right" class="xl65" width="74">9/27/2016</TD><TD align="right" class="xl65" width="74">9/26/2016</TD><TD align="right" class="xl65" width="74">9/25/2016</TD><TD align="right" class="xl65" width="74">9/24/2016</TD><TD align="right" class="xl65" width="74">9/23/2016</TD><TD align="right" class="xl65" width="74">9/22/2016</TD><TD align="right" class="xl65" width="74">9/21/2016</TD><TD align="right" class="xl65" width="75">9/20/2016</TD><TD align="right" class="xl65" width="72">9/19/2016</TD><TD align="right" class="xl65" width="72">9/18/2016</TD><TD align="right" class="xl65" width="72">9/17/2016</TD><TD align="right" class="xl65" width="72">9/16/2016</TD><TD align="right" class="xl65" width="72">9/15/2016</TD><TD align="right" class="xl65" width="72">9/14/2016</TD><TD align="right" class="xl65" width="72">9/13/2016</TD><TD align="right" class="xl65" width="72">9/12/2016</TD><TD align="right" class="xl65" width="72">9/11/2016</TD><TD align="right" class="xl65" width="72">9/10/2016</TD></TR><TR><TD height="20">Partner A</TD><TD align="right">100</TD><TD align="right">101</TD><TD align="right">102</TD><TD align="right">103</TD><TD align="right">104</TD><TD align="right">105</TD><TD align="right">106</TD><TD align="right">107</TD><TD align="right">108</TD><TD align="right">109</TD><TD align="right">110</TD><TD align="right">111</TD><TD align="right">112</TD><TD align="right">113</TD><TD align="right">114</TD><TD align="right">115</TD><TD align="right">116</TD><TD align="right">117</TD><TD align="right">118</TD><TD align="right">119</TD><TD align="right">120</TD><TD align="right">121</TD><TD align="right">122</TD><TD align="right">123</TD><TD align="right">124</TD><TD align="right">125</TD><TD align="right">126</TD><TD align="right">127</TD><TD align="right">128</TD><TD align="right">129</TD><TD align="right">130</TD><TD align="right">131</TD><TD align="right">132</TD><TD align="right">133</TD><TD align="right">134</TD><TD align="right">135</TD></TR><TR><TD height="20">Partner B</TD><TD align="right">276</TD><TD align="right">277</TD><TD align="right">278</TD><TD align="right">279</TD><TD align="right">280</TD><TD align="right">281</TD><TD align="right">282</TD><TD align="right">283</TD><TD align="right">284</TD><TD align="right">285</TD><TD align="right">286</TD><TD align="right">287</TD><TD align="right">288</TD><TD align="right">289</TD><TD align="right">290</TD><TD align="right">291</TD><TD align="right">292</TD><TD align="right">293</TD><TD align="right">294</TD><TD align="right">295</TD><TD align="right">296</TD><TD align="right">297</TD><TD align="right">298</TD><TD align="right">299</TD><TD align="right">300</TD><TD align="right">301</TD><TD align="right">302</TD><TD align="right">303</TD><TD align="right">304</TD><TD align="right">305</TD><TD align="right">306</TD><TD align="right">307</TD><TD align="right">308</TD><TD align="right">309</TD><TD align="right">310</TD><TD align="right">311</TD></TR><TR><TD height="20">Partner C</TD><TD align="right">50</TD><TD align="right">51</TD><TD align="right">52</TD><TD align="right">53</TD><TD align="right">54</TD><TD align="right">55</TD><TD align="right">56</TD><TD align="right">57</TD><TD align="right">58</TD><TD align="right">59</TD><TD align="right">60</TD><TD align="right">61</TD><TD align="right">62</TD><TD align="right">63</TD><TD align="right">64</TD><TD align="right">65</TD><TD align="right">66</TD><TD align="right">67</TD><TD align="right">68</TD><TD align="right">69</TD><TD align="right">70</TD><TD align="right">71</TD><TD align="right">72</TD><TD align="right">73</TD><TD align="right">74</TD><TD align="right">75</TD><TD align="right">76</TD><TD align="right">77</TD><TD align="right">78</TD><TD align="right">79</TD><TD align="right">80</TD><TD align="right">81</TD><TD align="right">82</TD><TD align="right">83</TD><TD align="right">84</TD><TD align="right">85</TD></TR><TR><TD height="20">Partner D</TD><TD align="right">177</TD><TD align="right">178</TD><TD align="right">179</TD><TD align="right">180</TD><TD align="right">181</TD><TD align="right">182</TD><TD align="right">183</TD><TD align="right">184</TD><TD align="right">185</TD><TD align="right">186</TD><TD align="right">187</TD><TD align="right">188</TD><TD align="right">189</TD><TD align="right">190</TD><TD align="right">191</TD><TD align="right">192</TD><TD align="right">193</TD><TD align="right">194</TD><TD align="right">195</TD><TD align="right">196</TD><TD align="right">197</TD><TD align="right">198</TD><TD align="right">199</TD><TD align="right">200</TD><TD align="right">201</TD><TD align="right">202</TD><TD align="right">203</TD><TD align="right">204</TD><TD align="right">205</TD><TD align="right">206</TD><TD align="right">207</TD><TD align="right">208</TD><TD align="right">209</TD><TD align="right">210</TD><TD align="right">211</TD><TD align="right">212</TD></TR></TBODY></TABLE><P></P><P></P><P>Required output:</P><P>   </P><TABLE border="0" cellpadding="0" cellspacing="0" width="1260"><TBODY><TR><TD class="xl69" colspan="4" height="20" width="351">Result Set (will always display latest 15 days)</TD></TR><TR><TD class="xl65" height="20">Date -></TD><TD align="right" class="xl66" style="border-left: none;">10/15/2016</TD><TD align="right" class="xl66" style="border-left: none;">10/14/2016</TD><TD align="right" class="xl66" style="border-left: none;">10/13/2016</TD><TD align="right" class="xl66" style="border-left: none;">10/12/2016</TD><TD align="right" class="xl66" style="border-left: none;">10/11/2016</TD><TD align="right" class="xl66" style="border-left: none;">10/10/2016</TD><TD align="right" class="xl66" style="border-left: none;">10/9/2016</TD><TD align="right" class="xl66" style="border-left: none;">10/8/2016</TD><TD align="right" class="xl66" style="border-left: none;">10/7/2016</TD><TD align="right" class="xl66" style="border-left: none;">10/6/2016</TD><TD align="right" class="xl66" style="border-left: none;">10/5/2016</TD><TD align="right" class="xl66" style="border-left: none;">10/4/2016</TD><TD align="right" class="xl66" style="border-left: none;">10/3/2016</TD><TD align="right" class="xl66" style="border-left: none;">10/2/2016</TD><TD align="right" class="xl66" style="border-left: none;">10/1/2016</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Partner A</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">93.0%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">93.1%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">93.2%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">93.2%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">93.3%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">93.3%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">93.4%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">93.4%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">93.5%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">93.6%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">93.6%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">93.7%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">93.7%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">93.8%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">93.8%</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Partner B</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">97.4%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">97.4%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">97.4%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">97.4%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">97.4%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">97.4%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">97.4%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">97.4%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">97.4%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">97.4%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">97.4%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">97.5%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">97.5%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">97.5%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">97.5%</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Partner C</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">87.0%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">87.2%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">87.4%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">87.6%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">87.8%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">88.0%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">88.2%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">88.4%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">88.5%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">88.7%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">88.9%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">89.1%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">89.2%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">89.4%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">89.5%</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Partner D</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">95.9%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">96.0%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">96.0%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">96.0%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">96.0%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">96.0%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">96.1%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">96.1%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">96.1%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">96.1%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">96.1%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">96.2%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">96.2%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">96.2%</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">96.2%</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 19 Oct 2016 19:22:06 GMT https://community.qlik.com/t5/QlikView/Rolling-Average-Calculation/m-p/1206313#M387663 2016-10-19T19:22:06Z