topic Re: Aggregated function Sum of Averages in QlikView https://community.qlik.com/t5/QlikView/Aggregated-function-Sum-of-Averages/m-p/648028#M474615 <HTML><HEAD></HEAD><BODY><P>thanks!</P></BODY></HTML> Mon, 08 Sep 2014 12:14:57 GMT 2014-09-08T12:14:57Z Aggregated function Sum of Averages https://community.qlik.com/t5/QlikView/Aggregated-function-Sum-of-Averages/m-p/648026#M474613 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>trying to sum the average amount for each branch as per below:</P><P></P><P> </P><P><SPAN style="font-size: 8pt;"><SPAN style="color: #0000ff;">Sum</SPAN>(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">avg</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Balance</SPAN><SPAN style="font-size: 8pt;">),</SPAN><SPAN style="color: #800000; font-size: 8pt;">Branch</SPAN><SPAN style="font-size: 8pt;">)) </SPAN></P><P> </P><P> </P><P><SPAN style="font-size: 8pt;">When selecting one time (ie 09:00) Im getting the correct value. </SPAN></P><P><SPAN style="font-size: 8pt;">However, Problem is I cannot plot these values in a graph (hour as dimension), neither can I show these values per hour in a Pivot. </SPAN></P><P><SPAN style="font-size: 8pt;">Im missing something here. Any clues? </SPAN></P><P> </P><P><SPAN style="font-size: 8pt;">Sample file attached. </SPAN></P><P> </P><P><SPAN style="font-size: 8pt;">Regards,</SPAN></P><P><SPAN style="font-size: 8pt;">Olle </SPAN></P><P><BR /> </P></BODY></HTML> Mon, 08 Sep 2014 12:09:04 GMT https://community.qlik.com/t5/QlikView/Aggregated-function-Sum-of-Averages/m-p/648026#M474613 2014-09-08T12:09:04Z Re: Aggregated function Sum of Averages https://community.qlik.com/t5/QlikView/Aggregated-function-Sum-of-Averages/m-p/648027#M474614 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try&nbsp; sum(aggr(avg(Balance),Branch,Time))</P><P></P><P>BR</P><P></P><P>Ariel</P></BODY></HTML> Mon, 08 Sep 2014 12:12:04 GMT https://community.qlik.com/t5/QlikView/Aggregated-function-Sum-of-Averages/m-p/648027#M474614 ariel_klien 2014-09-08T12:12:04Z Re: Aggregated function Sum of Averages https://community.qlik.com/t5/QlikView/Aggregated-function-Sum-of-Averages/m-p/648028#M474615 <HTML><HEAD></HEAD><BODY><P>thanks!</P></BODY></HTML> Mon, 08 Sep 2014 12:14:57 GMT https://community.qlik.com/t5/QlikView/Aggregated-function-Sum-of-Averages/m-p/648028#M474615 2014-09-08T12:14:57Z