topic Re: Total on Averaged value in QlikView https://community.qlik.com/t5/QlikView/Total-on-Averaged-value/m-p/463558#M486566 <HTML><HEAD></HEAD><BODY><P>Try: sum(total aggr(avg(Amount),Quarter))</P></BODY></HTML> Fri, 22 Feb 2013 17:45:01 GMT Gysbert_Wassenaar 2013-02-22T17:45:01Z Total on Averaged value https://community.qlik.com/t5/QlikView/Total-on-Averaged-value/m-p/463555#M486563 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have data on this format</P><TABLE border="0" cellpadding="0" cellspacing="0" width="256"><TBODY><TR><TD height="17" width="64">Year</TD><TD width="64">Quarter</TD><TD width="64">Month</TD><TD width="64">Amount</TD></TR><TR><TD align="right" height="17">2013</TD><TD>Q1</TD><TD align="right">1</TD><TD align="right">100</TD></TR><TR><TD align="right" height="17">2013</TD><TD>Q1</TD><TD align="right">2</TD><TD align="right">120</TD></TR><TR><TD align="right" height="17">2013</TD><TD>Q2</TD><TD align="right">4</TD><TD align="right">90</TD></TR><TR><TD align="right" height="17">2013</TD><TD>Q2</TD><TD align="right">5</TD><TD align="right">140</TD></TR><TR><TD align="right" height="17">2013</TD><TD>Q3</TD><TD align="right">7</TD><TD align="right">110</TD></TR><TR><TD align="right" height="17">2013</TD><TD>Q3</TD><TD align="right">8</TD><TD align="right">100</TD></TR><TR><TD align="right" height="17">2013</TD><TD>Q4</TD><TD align="right">11</TD><TD align="right">80</TD></TR><TR><TD align="right" height="17">2013</TD><TD>Q4</TD><TD align="right">12</TD><TD align="right">90</TD></TR></TBODY></TABLE><P></P><P>I wanted tocreate result as</P><TABLE border="0" cellpadding="0" cellspacing="0" width="305"><TBODY><TR><TD height="17" width="64">Year</TD><TD width="64">Quarter</TD><TD width="107">Quarter Average</TD><TD width="70">Year Total</TD></TR><TR><TD align="right" height="17">2013</TD><TD>Q1</TD><TD align="right">110</TD><TD align="right">415</TD></TR><TR><TD align="right" height="17">2013</TD><TD>Q2</TD><TD align="right">115</TD><TD align="right">415</TD></TR><TR><TD align="right" height="17">2013</TD><TD>Q3</TD><TD align="right">105</TD><TD align="right">415</TD></TR><TR><TD align="right" height="17">2013</TD><TD>Q4</TD><TD align="right">85</TD><TD align="right">415</TD></TR></TBODY></TABLE><P></P><P>Thanks,</P></BODY></HTML> Fri, 22 Feb 2013 14:25:05 GMT https://community.qlik.com/t5/QlikView/Total-on-Averaged-value/m-p/463555#M486563 2013-02-22T14:25:05Z Re: Total on Averaged value https://community.qlik.com/t5/QlikView/Total-on-Averaged-value/m-p/463556#M486564 <HTML><HEAD></HEAD><BODY><P>Create Chart. Use Year and Quarter as dimensions.</P><P>Quarter Average =Avg(Amount)</P><P>Year Total =Sum(total Amount)</P></BODY></HTML> Fri, 22 Feb 2013 16:15:47 GMT https://community.qlik.com/t5/QlikView/Total-on-Averaged-value/m-p/463556#M486564 whiteline 2013-02-22T16:15:47Z Re: Total on Averaged value https://community.qlik.com/t5/QlikView/Total-on-Averaged-value/m-p/463557#M486565 <HTML><HEAD></HEAD><BODY><P>Hi Whiteline,</P><P>Thank you for your reply.</P><P></P><P>I tried to code that way. The result is attached.</P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Year</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Quarter</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>avg(Amount)</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>sum(TOTAL Amount)</STRONG></SPAN><STRONG> </STRONG></TH></TR><TR bgcolor="#f5f5f5"><TD bgcolor="#f5f5f5"><BR /></TD><TD bgcolor="#f5f5f5"><BR /></TD><TD bgcolor="#f5f5f5"><STRONG>103.75 </STRONG></TD><TD bgcolor="#f5f5f5"><STRONG>830 </STRONG></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2013</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Q1</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">110</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">830</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2013</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Q2</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">115</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">830</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2013</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Q3</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">105</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">830</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2013</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Q4</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">85</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">830</SPAN></TD></TR></TBODY></TABLE><P>Please advice. The toal column should be 415 rather 830.</P></BODY></HTML> Fri, 22 Feb 2013 17:36:12 GMT https://community.qlik.com/t5/QlikView/Total-on-Averaged-value/m-p/463557#M486565 2013-02-22T17:36:12Z Re: Total on Averaged value https://community.qlik.com/t5/QlikView/Total-on-Averaged-value/m-p/463558#M486566 <HTML><HEAD></HEAD><BODY><P>Try: sum(total aggr(avg(Amount),Quarter))</P></BODY></HTML> Fri, 22 Feb 2013 17:45:01 GMT https://community.qlik.com/t5/QlikView/Total-on-Averaged-value/m-p/463558#M486566 Gysbert_Wassenaar 2013-02-22T17:45:01Z