topic Average top 4 above. in QlikView https://community.qlik.com/t5/QlikView/Average-top-4-above/m-p/500597#M187081 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps">HI.</SPAN></P><P><SPAN class="hps">I need</SPAN> <SPAN class="hps">to compare each</SPAN> <SPAN class="hps">AñoMes</SPAN> <SPAN class="hps">with</SPAN> <SPAN class="hps">the top 4</SPAN> <SPAN class="hps">of</SPAN> <SPAN class="hps">the last 12</SPAN>.</P><P><SPAN class="hps"><SPAN class="hps">In</SPAN> <SPAN class="hps">the attached example:</SPAN></SPAN></P><P><SPAN class="hps">1.</SPAN> <SPAN class="hps">Nov 13</SPAN> <SPAN class="hps">=</SPAN> <SPAN class="hps">Oct 13</SPAN>, <SPAN class="hps">Sep</SPAN> 13, <SPAN class="hps">Apr 13 </SPAN><SPAN class="hps">and</SPAN> <SPAN class="hps">Feb 13</SPAN>.</P><P><SPAN class="hps">2</SPAN>. <SPAN class="hps">Oct 13</SPAN> <SPAN class="hps">=</SPAN> <SPAN class="hps">Sep</SPAN> <SPAN class="hps">13</SPAN>, Ago <SPAN class="hps">13</SPAN>, <SPAN class="hps">Apr 13</SPAN> <SPAN class="hps">and</SPAN> <SPAN class="hps">Feb 13</SPAN>.</P><P>3. <SPAN class="hps">Sep</SPAN> <SPAN class="hps">13 =</SPAN> Ago <SPAN class="hps">13</SPAN>, <SPAN class="hps">Apr 13</SPAN>, <SPAN class="hps">Feb 13</SPAN> <SPAN class="hps">and</SPAN> <SPAN class="hps">Oct 12</SPAN></P><P><SPAN class="hps">and so on.</SPAN></P><P><SPAN class="hps">The calculation</SPAN> <SPAN class="hps">would be</SPAN> <SPAN class="hps">the month</SPAN> <SPAN class="hps">on</SPAN> <SPAN class="hps">the average of</SPAN> <SPAN class="hps">the top 4</SPAN>.</P><P><SPAN class="hps">In example 1</SPAN> <SPAN class="hps">=</SPAN> <SPAN class="hps">Nov 13</SPAN> <SPAN class="hps">/</SPAN> <SPAN class="hps">average</SPAN> <SPAN class="hps">Oct 13</SPAN>, <SPAN class="hps">Sep</SPAN> <SPAN class="hps">Apr 13 </SPAN><SPAN class="hps">and</SPAN> <SPAN class="hps">Feb 13</SPAN>.</P><P></P><P><SPAN class="hps">Regards.</SPAN></P></BODY></HTML> Fri, 08 Nov 2013 21:21:10 GMT spividori 2013-11-08T21:21:10Z Average top 4 above. https://community.qlik.com/t5/QlikView/Average-top-4-above/m-p/500597#M187081 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps">HI.</SPAN></P><P><SPAN class="hps">I need</SPAN> <SPAN class="hps">to compare each</SPAN> <SPAN class="hps">AñoMes</SPAN> <SPAN class="hps">with</SPAN> <SPAN class="hps">the top 4</SPAN> <SPAN class="hps">of</SPAN> <SPAN class="hps">the last 12</SPAN>.</P><P><SPAN class="hps"><SPAN class="hps">In</SPAN> <SPAN class="hps">the attached example:</SPAN></SPAN></P><P><SPAN class="hps">1.</SPAN> <SPAN class="hps">Nov 13</SPAN> <SPAN class="hps">=</SPAN> <SPAN class="hps">Oct 13</SPAN>, <SPAN class="hps">Sep</SPAN> 13, <SPAN class="hps">Apr 13 </SPAN><SPAN class="hps">and</SPAN> <SPAN class="hps">Feb 13</SPAN>.</P><P><SPAN class="hps">2</SPAN>. <SPAN class="hps">Oct 13</SPAN> <SPAN class="hps">=</SPAN> <SPAN class="hps">Sep</SPAN> <SPAN class="hps">13</SPAN>, Ago <SPAN class="hps">13</SPAN>, <SPAN class="hps">Apr 13</SPAN> <SPAN class="hps">and</SPAN> <SPAN class="hps">Feb 13</SPAN>.</P><P>3. <SPAN class="hps">Sep</SPAN> <SPAN class="hps">13 =</SPAN> Ago <SPAN class="hps">13</SPAN>, <SPAN class="hps">Apr 13</SPAN>, <SPAN class="hps">Feb 13</SPAN> <SPAN class="hps">and</SPAN> <SPAN class="hps">Oct 12</SPAN></P><P><SPAN class="hps">and so on.</SPAN></P><P><SPAN class="hps">The calculation</SPAN> <SPAN class="hps">would be</SPAN> <SPAN class="hps">the month</SPAN> <SPAN class="hps">on</SPAN> <SPAN class="hps">the average of</SPAN> <SPAN class="hps">the top 4</SPAN>.</P><P><SPAN class="hps">In example 1</SPAN> <SPAN class="hps">=</SPAN> <SPAN class="hps">Nov 13</SPAN> <SPAN class="hps">/</SPAN> <SPAN class="hps">average</SPAN> <SPAN class="hps">Oct 13</SPAN>, <SPAN class="hps">Sep</SPAN> <SPAN class="hps">Apr 13 </SPAN><SPAN class="hps">and</SPAN> <SPAN class="hps">Feb 13</SPAN>.</P><P></P><P><SPAN class="hps">Regards.</SPAN></P></BODY></HTML> Fri, 08 Nov 2013 21:21:10 GMT https://community.qlik.com/t5/QlikView/Average-top-4-above/m-p/500597#M187081 spividori 2013-11-08T21:21:10Z Re: Average top 4 above. https://community.qlik.com/t5/QlikView/Average-top-4-above/m-p/500598#M187082 <HTML><HEAD></HEAD><BODY><P>please attach your excel sheet</P></BODY></HTML> Sat, 09 Nov 2013 06:32:40 GMT https://community.qlik.com/t5/QlikView/Average-top-4-above/m-p/500598#M187082 2013-11-09T06:32:40Z Re: Average top 4 above. https://community.qlik.com/t5/QlikView/Average-top-4-above/m-p/500599#M187083 <HTML><HEAD></HEAD><BODY><P>See attached qvw.</P></BODY></HTML> Sat, 09 Nov 2013 09:56:47 GMT https://community.qlik.com/t5/QlikView/Average-top-4-above/m-p/500599#M187083 Gysbert_Wassenaar 2013-11-09T09:56:47Z Re: Average top 4 above. https://community.qlik.com/t5/QlikView/Average-top-4-above/m-p/500600#M187084 <HTML><HEAD></HEAD><BODY><P>Gysbert you solution is very good for small data sets.</P><P></P><P>Is there any way we can achive on the UI level ?</P></BODY></HTML> Sat, 09 Nov 2013 14:59:26 GMT https://community.qlik.com/t5/QlikView/Average-top-4-above/m-p/500600#M187084 2013-11-09T14:59:26Z Re: Re: Average top 4 above. https://community.qlik.com/t5/QlikView/Average-top-4-above/m-p/500601#M187085 <HTML><HEAD></HEAD><BODY><P>Hi Gysbert.</P><P><SPAN class="hps">I need to do</SPAN> <SPAN class="hps">the calculation</SPAN> <SPAN class="hps">on the chart</SPAN> <SPAN class="hps">or if</SPAN> <SPAN class="hps">it</SPAN> <SPAN class="hps">could be done in</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">script</SPAN>, too, <SPAN class="hps">because in my</SPAN> <SPAN class="hps">application</SPAN> <SPAN class="hps">each month has</SPAN> <SPAN class="hps">several moves</SPAN> <SPAN class="hps">and they</SPAN> <SPAN class="hps">are related to</SPAN> <SPAN class="hps">customers.</SPAN></P><P><SPAN class="hps">I upload a</SPAN> <SPAN class="hps">excel</SPAN> <SPAN class="hps">for</SPAN> <SPAN class="hps">you to understand</SPAN> <SPAN class="hps">better.</SPAN> <SPAN class="hps">Thank you.</SPAN></P><P></P><P><SPAN class="hps">Regards.</SPAN></P></BODY></HTML> Mon, 11 Nov 2013 15:28:36 GMT https://community.qlik.com/t5/QlikView/Average-top-4-above/m-p/500601#M187085 spividori 2013-11-11T15:28:36Z