topic Mean in QlikView https://community.qlik.com/t5/QlikView/Mean/m-p/356065#M132151 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps"> </SPAN></P><P><SPAN class="hps"><SPAN class="hps">I'm really not</SPAN> <SPAN class="hps">good at this......</SPAN><BR /></SPAN></P><P><SPAN class="hps">A small</SPAN> <SPAN class="hps">clarification</SPAN></P><P></P><P> <SPAN class="hps">I</SPAN> <SPAN class="hps">want to calculate</SPAN> <SPAN class="hps">the mean</SPAN> <SPAN class="hps">number of</SPAN> <SPAN class="hps">overnight accommodation,</SPAN> <SPAN class="hps">housing and</SPAN> <SPAN class="hps">quarters.</SPAN></P><P></P><P> <SPAN class="hps atn">Sum (</SPAN><SPAN>Weight</SPAN><SPAN>) /</SPAN> <SPAN class="hps atn">Sum (</SPAN><SPAN>Total</SPAN> <SPAN class="hps">&lt;Year_quarters&gt;</SPAN> <SPAN class="hps">weight</SPAN><SPAN>) and I have</SPAN> <SPAN class="hps">been</SPAN> <SPAN class="hps">given</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">distribution</SPAN> <SPAN class="hps">of this formula</SPAN></P></BODY></HTML> Fri, 16 Mar 2012 14:11:08 GMT 2012-03-16T14:11:08Z Mean https://community.qlik.com/t5/QlikView/Mean/m-p/356061#M132147 <HTML><HEAD></HEAD><BODY><P> <SPAN class="hps">Hello</SPAN><SPAN>!</SPAN></P><P></P><P> <SPAN class="hps">I will try to</SPAN> <SPAN class="hps">calculate an average</SPAN><SPAN>, and I</SPAN> <SPAN class="hps">do not really know</SPAN> <SPAN class="hps">how I do,</SPAN> <SPAN class="hps">I</SPAN> <SPAN class="hps">now have a</SPAN> <SPAN class="hps">formula:</SPAN> <SPAN class="hps atn">Sum (</SPAN><SPAN>Weight</SPAN><SPAN>) /</SPAN> <SPAN class="hps atn">Sum (</SPAN><SPAN>Total</SPAN> <SPAN class="hps atn">&lt;</SPAN><SPAN>ÅR_Kvartal</SPAN><SPAN>&gt; Weight</SPAN><SPAN>).</SPAN> <SPAN class="hps">This formula</SPAN> <SPAN class="hps">can I use</SPAN> <SPAN class="hps">if I have to</SPAN> <SPAN class="hps">figure out</SPAN> <SPAN class="hps">the distribution</SPAN> <SPAN class="hps">or total number</SPAN> <SPAN class="hps">for each</SPAN> <SPAN class="hps">answer.</SPAN></P><P></P><P> <SPAN class="hps">But how</SPAN> <SPAN class="hps">do I</SPAN> <SPAN class="hps">calculate</SPAN> <SPAN class="hps">average values</SPAN> <SPAN class="hps">​​of the respective</SPAN> <SPAN class="hps">responses</SPAN><SPAN>?</SPAN></P></BODY></HTML> Fri, 16 Mar 2012 13:56:07 GMT https://community.qlik.com/t5/QlikView/Mean/m-p/356061#M132147 2012-03-16T13:56:07Z Mean https://community.qlik.com/t5/QlikView/Mean/m-p/356062#M132148 <HTML><HEAD></HEAD><BODY><P style="font-weight: bold;">aggr(Avg(Weight), Responses )&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P style="font-weight: bold;">Responses = name of field for responses</P><P style="font-weight: bold;">This will show you the average weight by reponse</P></BODY></HTML> Fri, 16 Mar 2012 14:01:29 GMT https://community.qlik.com/t5/QlikView/Mean/m-p/356062#M132148 jvitantonio 2012-03-16T14:01:29Z Mean https://community.qlik.com/t5/QlikView/Mean/m-p/356063#M132149 <HTML><HEAD></HEAD><BODY><P> <SPAN class="hps">Hello again!</SPAN></P><P></P><P> <SPAN class="hps">But I</SPAN> <SPAN class="hps">want to calculate</SPAN> <SPAN class="hps">the mean</SPAN> <SPAN class="hps">number of</SPAN> <SPAN class="hps">nights,</SPAN> <SPAN class="hps">do I</SPAN> <SPAN class="hps">then set</SPAN> <SPAN class="hps">it</SPAN> <SPAN class="hps">there instead</SPAN><SPAN>?</SPAN></P></BODY></HTML> Fri, 16 Mar 2012 14:03:57 GMT https://community.qlik.com/t5/QlikView/Mean/m-p/356063#M132149 2012-03-16T14:03:57Z Mean https://community.qlik.com/t5/QlikView/Mean/m-p/356064#M132150 <HTML><HEAD></HEAD><BODY><P>well, I&nbsp; put "weight" because it doesn't say anytihng about nights <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> You can replace the formula according to your needs</P></BODY></HTML> Fri, 16 Mar 2012 14:09:59 GMT https://community.qlik.com/t5/QlikView/Mean/m-p/356064#M132150 jvitantonio 2012-03-16T14:09:59Z Mean https://community.qlik.com/t5/QlikView/Mean/m-p/356065#M132151 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps"> </SPAN></P><P><SPAN class="hps"><SPAN class="hps">I'm really not</SPAN> <SPAN class="hps">good at this......</SPAN><BR /></SPAN></P><P><SPAN class="hps">A small</SPAN> <SPAN class="hps">clarification</SPAN></P><P></P><P> <SPAN class="hps">I</SPAN> <SPAN class="hps">want to calculate</SPAN> <SPAN class="hps">the mean</SPAN> <SPAN class="hps">number of</SPAN> <SPAN class="hps">overnight accommodation,</SPAN> <SPAN class="hps">housing and</SPAN> <SPAN class="hps">quarters.</SPAN></P><P></P><P> <SPAN class="hps atn">Sum (</SPAN><SPAN>Weight</SPAN><SPAN>) /</SPAN> <SPAN class="hps atn">Sum (</SPAN><SPAN>Total</SPAN> <SPAN class="hps">&lt;Year_quarters&gt;</SPAN> <SPAN class="hps">weight</SPAN><SPAN>) and I have</SPAN> <SPAN class="hps">been</SPAN> <SPAN class="hps">given</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">distribution</SPAN> <SPAN class="hps">of this formula</SPAN></P></BODY></HTML> Fri, 16 Mar 2012 14:11:08 GMT https://community.qlik.com/t5/QlikView/Mean/m-p/356065#M132151 2012-03-16T14:11:08Z Mean https://community.qlik.com/t5/QlikView/Mean/m-p/356066#M132152 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps">But how</SPAN> <SPAN class="hps">do I write</SPAN> <SPAN class="hps">this expression</SPAN><SPAN>?</SPAN></P></BODY></HTML> Fri, 16 Mar 2012 14:29:47 GMT https://community.qlik.com/t5/QlikView/Mean/m-p/356066#M132152 2012-03-16T14:29:47Z Mean https://community.qlik.com/t5/QlikView/Mean/m-p/356067#M132153 <HTML><HEAD></HEAD><BODY><P>sorry, you'll need to post your app. because I don't get what ur saying</P></BODY></HTML> Fri, 16 Mar 2012 16:51:57 GMT https://community.qlik.com/t5/QlikView/Mean/m-p/356067#M132153 jvitantonio 2012-03-16T16:51:57Z