topic Weighted Average in QlikView https://community.qlik.com/t5/QlikView/Weighted-Average/m-p/166690#M38553 <HTML><HEAD></HEAD><BODY><P>Ok..I have the answer now...It was around tweaking the expression!!</P></BODY></HTML> Mon, 01 Nov 2010 17:44:21 GMT parpatra 2010-11-01T17:44:21Z Weighted Average https://community.qlik.com/t5/QlikView/Weighted-Average/m-p/166689#M38552 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 195pt; border-collapse: collapse;" width="260"><COLGROUP><COL style="width: 51pt; mso-width-source: userset; mso-width-alt: 2486;" width="68" /><COL span="3" style="width: 48pt;" width="64" /></COLGROUP><TBODY><TR height="20" style="height: 15pt;"><TD class="xl67" height="20" style="width: 51pt; height: 15pt; background-color: transparent; border: windowtext 0.5pt solid;" width="68"><STRONG>Month</STRONG></TD><TD class="xl67" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; width: 48pt; border-bottom: windowtext 0.5pt solid; background-color: transparent;" width="64"><STRONG>Location</STRONG></TD><TD class="xl67" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; width: 48pt; border-bottom: windowtext 0.5pt solid; background-color: transparent;" width="64"><STRONG>A</STRONG></TD><TD class="xl67" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid; border-left: windowtext; width: 48pt; border-bottom: windowtext 0.5pt solid; background-color: transparent;" width="64"><STRONG>B</STRONG></TD></TR><TR height="20" style="height: 15pt;"><TD align="right" class="xl66" height="20" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 15pt; background-color: transparent;">1/1/2010</TD><TD class="xl65" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">A</TD><TD align="right" class="xl65" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">10</TD><TD align="right" class="xl65" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">15</TD></TR><TR height="20" style="height: 15pt;"><TD align="right" class="xl66" height="20" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 15pt; background-color: transparent;">1/1/2010</TD><TD class="xl65" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">B</TD><TD align="right" class="xl65" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">15</TD><TD align="right" class="xl65" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">20</TD></TR><TR height="20" style="height: 15pt;"><TD align="right" class="xl66" height="20" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 15pt; background-color: transparent;">1/1/2010</TD><TD class="xl65" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">C</TD><TD align="right" class="xl65" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">20</TD><TD align="right" class="xl65" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">25</TD></TR><TR height="20" style="height: 15pt;"><TD align="right" class="xl66" height="20" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 15pt; background-color: transparent;">2/1/2010</TD><TD class="xl65" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">A</TD><TD align="right" class="xl65" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">25</TD><TD align="right" class="xl65" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">30</TD></TR><TR height="20" style="height: 15pt;"><TD align="right" class="xl66" height="20" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 15pt; background-color: transparent;">2/1/2010</TD><TD class="xl65" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">B</TD><TD align="right" class="xl65" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">30</TD><TD align="right" class="xl65" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">35</TD></TR><TR height="20" style="height: 15pt;"><TD align="right" class="xl66" height="20" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 15pt; background-color: transparent;">2/1/2010</TD><TD class="xl65" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">C</TD><TD align="right" class="xl65" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">35</TD><TD align="right" class="xl65" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">40</TD></TR><TR height="20" style="height: 15pt;"><TD align="right" class="xl66" height="20" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 15pt; background-color: transparent;">3/1/2010</TD><TD class="xl65" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">A</TD><TD align="right" class="xl65" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">40</TD><TD align="right" class="xl65" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">45</TD></TR><TR height="20" style="height: 15pt;"><TD align="right" class="xl66" height="20" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 15pt; background-color: transparent;">3/1/2010</TD><TD class="xl65" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">B</TD><TD align="right" class="xl65" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">45</TD><TD align="right" class="xl65" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">50</TD></TR><TR height="20" style="height: 15pt;"><TD align="right" class="xl66" height="20" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext 0.5pt solid; border-bottom: windowtext 0.5pt solid; height: 15pt; background-color: transparent;">3/1/2010</TD><TD class="xl65" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">C</TD><TD align="right" class="xl65" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">50</TD><TD align="right" class="xl65" style="border-right: windowtext 0.5pt solid; border-top: windowtext; border-left: windowtext; border-bottom: windowtext 0.5pt solid; background-color: transparent;">55</TD></TR></TBODY></TABLE><P>Please help me with the expression.</P><P>MV=(A/B)*(365/Numberof days in month)</P><P>Avg=(MV1/31+MV2/28+MV3/31)/(31+28+31)</P><P>I am good with calculating MVs on chart but I need to show the avg in a pivot table for multiple selection of months.</P><P>Thanks in advance!!</P></BODY></HTML> Mon, 01 Nov 2010 16:35:47 GMT https://community.qlik.com/t5/QlikView/Weighted-Average/m-p/166689#M38552 parpatra 2010-11-01T16:35:47Z Weighted Average https://community.qlik.com/t5/QlikView/Weighted-Average/m-p/166690#M38553 <HTML><HEAD></HEAD><BODY><P>Ok..I have the answer now...It was around tweaking the expression!!</P></BODY></HTML> Mon, 01 Nov 2010 17:44:21 GMT https://community.qlik.com/t5/QlikView/Weighted-Average/m-p/166690#M38553 parpatra 2010-11-01T17:44:21Z