topic DAYS OVER YEARS PIVOT AVERAGE in QlikView https://community.qlik.com/t5/QlikView/DAYS-OVER-YEARS-PIVOT-AVERAGE/m-p/738285#M473876 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 904px; background: white;"><TBODY><TR><TD style="border: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom" width="75"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><STRONG style=": ; color: #3d3d3d; font-size: 10pt; font-family: 'inherit','serif';">WEEKDAY/ YEAR</STRONG></P></TD><TD style="border: solid black 1.0pt; border-left: none; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom" width="85"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="font-size: 10pt;"><STRONG style="color: #3d3d3d; font-family: inherit, serif;">Y12</STRONG></SPAN></P></TD><TD style="border: solid black 1.0pt; border-left: none; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom" width="85"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="font-size: 10pt;"><STRONG style="color: #3d3d3d; font-family: inherit, serif;">Y13</STRONG></SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt;"><EM style="color: #3d3d3d; font-family: inherit, serif;">mon</EM></SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">USD&nbsp;&nbsp;&nbsp;&nbsp; 7.834</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">USD&nbsp;&nbsp;&nbsp;&nbsp; 2.393</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt;"><EM style="color: #3d3d3d; font-family: inherit, serif;">tue</EM></SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">USD&nbsp;&nbsp; 19.831</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">USD&nbsp;&nbsp;&nbsp;&nbsp; 4.724</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt;"><EM style="color: #3d3d3d; font-family: inherit, serif;">wed</EM></SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">USD&nbsp;&nbsp; 14.120</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">USD&nbsp;&nbsp; 17.222</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt;"><EM style="color: #3d3d3d; font-family: inherit, serif;">thu</EM></SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">USD&nbsp;&nbsp;&nbsp;&nbsp; 4.026</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">USD&nbsp;&nbsp; 19.265</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt;"><EM style="color: #3d3d3d; font-family: inherit, serif;">fri</EM></SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">USD&nbsp;&nbsp;&nbsp;&nbsp; 8.423</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">USD&nbsp;&nbsp;&nbsp;&nbsp; 7.196</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt;"><EM style="color: #3d3d3d; font-family: inherit, serif;">sat</EM></SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">USD&nbsp;&nbsp;&nbsp;&nbsp; 9.694</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">USD&nbsp;&nbsp; 17.589</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt;"><EM style="color: #3d3d3d; font-family: inherit, serif;">sun</EM></SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">USD&nbsp;&nbsp; 19.608</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">USD&nbsp;&nbsp; 12.448</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt;"><STRONG style="color: #3d3d3d; font-family: inherit, serif;">AVG</STRONG></SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt;"><STRONG style="color: #3d3d3d; font-family: inherit, serif;">USD 11.934</STRONG></SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt;"><STRONG style="color: #3d3d3d; font-family: inherit, serif;">USD 11.548</STRONG></SPAN></P></TD></TR></TBODY></TABLE><P style="margin-bottom: .0001pt; background: white;"><SPAN style="font-size: 24.5pt; font-family: 'Helvetica','sans-serif'; color: #3d3d3d;"> </SPAN></P><P style="margin-bottom: .0001pt; background: white;"><SPAN style="font-size: 10pt; font-family: Helvetica, sans-serif; color: #3d3d3d;">i have the above data-set in a qlik pivot table. daily values are calculated with "sum()/count()" method; now i'd like to divide each daily value, each row, for the global yearly average (i.e. 11934 for year 2012 or first column last row). can i do that? if yes, how?!?</SPAN></P><P style="margin-bottom: .0001pt; background: white;"><SPAN style="color: #3d3d3d; font-size: 10pt; font-family: 'Helvetica','sans-serif';">below my desired result (a sort of coefficient, pure numbers):</SPAN></P><P style="margin-bottom: .0001pt; background: white;"><SPAN style="font-size: 24.5pt; font-family: 'Helvetica','sans-serif'; color: #3d3d3d;"> </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="background: white;" width="783"><TBODY><TR><TD style="border: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom" width="75"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><STRONG style=": ; color: #3d3d3d; font-size: 10pt; font-family: 'inherit','serif';">WEEKDAY/ YEAR</STRONG></P></TD><TD style="border: solid black 1.0pt; border-left: none; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom" width="85"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="font-size: 10pt;"><STRONG style="color: #3d3d3d; font-family: inherit, serif;">Y12</STRONG></SPAN></P></TD><TD style="border: solid black 1.0pt; border-left: none; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom" width="85"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="font-size: 10pt;"><STRONG style="color: #3d3d3d; font-family: inherit, serif;">Y13</STRONG></SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">mon</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;"> 0,66</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;"> 0,21</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">tue</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;"> 1,66</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;"> 0,41</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">wed</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;"> 1,18</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;"> 1,49</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">thu</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;"> 0,34</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;"> 1,67</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">fri</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;"> 0,71</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;"> 0,62</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">sdt</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;"> 0,81</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;"> 1,52</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">sun</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;"> 1,64</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;"> 1,08</SPAN></P></TD></TR></TBODY></TABLE></BODY></HTML> Thu, 16 Oct 2014 09:35:43 GMT Anonymous 2014-10-16T09:35:43Z DAYS OVER YEARS PIVOT AVERAGE https://community.qlik.com/t5/QlikView/DAYS-OVER-YEARS-PIVOT-AVERAGE/m-p/738285#M473876 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 904px; background: white;"><TBODY><TR><TD style="border: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom" width="75"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><STRONG style=": ; color: #3d3d3d; font-size: 10pt; font-family: 'inherit','serif';">WEEKDAY/ YEAR</STRONG></P></TD><TD style="border: solid black 1.0pt; border-left: none; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom" width="85"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="font-size: 10pt;"><STRONG style="color: #3d3d3d; font-family: inherit, serif;">Y12</STRONG></SPAN></P></TD><TD style="border: solid black 1.0pt; border-left: none; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom" width="85"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="font-size: 10pt;"><STRONG style="color: #3d3d3d; font-family: inherit, serif;">Y13</STRONG></SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt;"><EM style="color: #3d3d3d; font-family: inherit, serif;">mon</EM></SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">USD&nbsp;&nbsp;&nbsp;&nbsp; 7.834</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">USD&nbsp;&nbsp;&nbsp;&nbsp; 2.393</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt;"><EM style="color: #3d3d3d; font-family: inherit, serif;">tue</EM></SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">USD&nbsp;&nbsp; 19.831</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">USD&nbsp;&nbsp;&nbsp;&nbsp; 4.724</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt;"><EM style="color: #3d3d3d; font-family: inherit, serif;">wed</EM></SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">USD&nbsp;&nbsp; 14.120</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">USD&nbsp;&nbsp; 17.222</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt;"><EM style="color: #3d3d3d; font-family: inherit, serif;">thu</EM></SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">USD&nbsp;&nbsp;&nbsp;&nbsp; 4.026</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">USD&nbsp;&nbsp; 19.265</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt;"><EM style="color: #3d3d3d; font-family: inherit, serif;">fri</EM></SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">USD&nbsp;&nbsp;&nbsp;&nbsp; 8.423</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">USD&nbsp;&nbsp;&nbsp;&nbsp; 7.196</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt;"><EM style="color: #3d3d3d; font-family: inherit, serif;">sat</EM></SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">USD&nbsp;&nbsp;&nbsp;&nbsp; 9.694</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">USD&nbsp;&nbsp; 17.589</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt;"><EM style="color: #3d3d3d; font-family: inherit, serif;">sun</EM></SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">USD&nbsp;&nbsp; 19.608</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">USD&nbsp;&nbsp; 12.448</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt;"><STRONG style="color: #3d3d3d; font-family: inherit, serif;">AVG</STRONG></SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt;"><STRONG style="color: #3d3d3d; font-family: inherit, serif;">USD 11.934</STRONG></SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt;"><STRONG style="color: #3d3d3d; font-family: inherit, serif;">USD 11.548</STRONG></SPAN></P></TD></TR></TBODY></TABLE><P style="margin-bottom: .0001pt; background: white;"><SPAN style="font-size: 24.5pt; font-family: 'Helvetica','sans-serif'; color: #3d3d3d;"> </SPAN></P><P style="margin-bottom: .0001pt; background: white;"><SPAN style="font-size: 10pt; font-family: Helvetica, sans-serif; color: #3d3d3d;">i have the above data-set in a qlik pivot table. daily values are calculated with "sum()/count()" method; now i'd like to divide each daily value, each row, for the global yearly average (i.e. 11934 for year 2012 or first column last row). can i do that? if yes, how?!?</SPAN></P><P style="margin-bottom: .0001pt; background: white;"><SPAN style="color: #3d3d3d; font-size: 10pt; font-family: 'Helvetica','sans-serif';">below my desired result (a sort of coefficient, pure numbers):</SPAN></P><P style="margin-bottom: .0001pt; background: white;"><SPAN style="font-size: 24.5pt; font-family: 'Helvetica','sans-serif'; color: #3d3d3d;"> </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="background: white;" width="783"><TBODY><TR><TD style="border: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom" width="75"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><STRONG style=": ; color: #3d3d3d; font-size: 10pt; font-family: 'inherit','serif';">WEEKDAY/ YEAR</STRONG></P></TD><TD style="border: solid black 1.0pt; border-left: none; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom" width="85"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="font-size: 10pt;"><STRONG style="color: #3d3d3d; font-family: inherit, serif;">Y12</STRONG></SPAN></P></TD><TD style="border: solid black 1.0pt; border-left: none; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom" width="85"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="font-size: 10pt;"><STRONG style="color: #3d3d3d; font-family: inherit, serif;">Y13</STRONG></SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">mon</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;"> 0,66</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;"> 0,21</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">tue</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;"> 1,66</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;"> 0,41</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">wed</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;"> 1,18</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;"> 1,49</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">thu</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;"> 0,34</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;"> 1,67</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">fri</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;"> 0,71</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;"> 0,62</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">sdt</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;"> 0,81</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;"> 1,52</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;">sun</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;"> 1,64</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 3.8pt 7.6pt 3.8pt 7.6pt;" valign="bottom"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10pt; font-family: inherit, serif; color: #3d3d3d;"> 1,08</SPAN></P></TD></TR></TBODY></TABLE></BODY></HTML> Thu, 16 Oct 2014 09:35:43 GMT https://community.qlik.com/t5/QlikView/DAYS-OVER-YEARS-PIVOT-AVERAGE/m-p/738285#M473876 Anonymous 2014-10-16T09:35:43Z Re: DAYS OVER YEARS PIVOT AVERAGE https://community.qlik.com/t5/QlikView/DAYS-OVER-YEARS-PIVOT-AVERAGE/m-p/738286#M473877 <HTML><HEAD></HEAD><BODY><P>solved! this is the code:</P><P></P><P>=(sum (Sales)/count(WeekDay))</P><P>/</P><P>(sum (TOTAL &lt;Year&gt; Sales)/count(total &lt;Year&gt; WeekDay))</P><P></P><P>it's a matter of ignoring dimensions in aggregating functions. find <A _jive_internal="true" href="https://community.qlik.com/thread/86248">this topic</A></P></BODY></HTML> Tue, 28 Oct 2014 09:13:11 GMT https://community.qlik.com/t5/QlikView/DAYS-OVER-YEARS-PIVOT-AVERAGE/m-p/738286#M473877 Anonymous 2014-10-28T09:13:11Z