topic Re: Aggr function problem in QlikView https://community.qlik.com/t5/QlikView/Aggr-function-problem/m-p/758450#M269930 <HTML><HEAD></HEAD><BODY><P>Why can't you use Product and Customer as dimensions and sum([Value AY]) as expression?</P><P>What's the purpose of this nest of nested sums?</P></BODY></HTML> Tue, 04 Nov 2014 08:29:49 GMT Gysbert_Wassenaar 2014-11-04T08:29:49Z Aggr function problem https://community.qlik.com/t5/QlikView/Aggr-function-problem/m-p/758449#M269929 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>i have problem with aggr function. I used this function to aggregate Volume per Customer and his products.</P><P></P><P>sum(aggr(</P><P></P><P>sum([Volume AY])</P><P>/sum({&lt;[Product Group]=&gt;}(aggr(sum(([Volume AY])),Customer)))</P><P></P><P>,Customer,[Product Group]))</P><P></P><P>It works, but it takes (aggr) only one value (one product). Other values show as zero.</P><P>Where is the mistake? Why takes only one value?</P><P></P><P>Thanks for advice.</P><P></P><P>T.</P></BODY></HTML> Mon, 03 Nov 2014 23:39:48 GMT https://community.qlik.com/t5/QlikView/Aggr-function-problem/m-p/758449#M269929 2014-11-03T23:39:48Z Re: Aggr function problem https://community.qlik.com/t5/QlikView/Aggr-function-problem/m-p/758450#M269930 <HTML><HEAD></HEAD><BODY><P>Why can't you use Product and Customer as dimensions and sum([Value AY]) as expression?</P><P>What's the purpose of this nest of nested sums?</P></BODY></HTML> Tue, 04 Nov 2014 08:29:49 GMT https://community.qlik.com/t5/QlikView/Aggr-function-problem/m-p/758450#M269930 Gysbert_Wassenaar 2014-11-04T08:29:49Z