topic Re: Write an aggr expression in QlikView https://community.qlik.com/t5/QlikView/Write-an-aggr-expression/m-p/664619#M242011 <HTML><HEAD></HEAD><BODY><P>Can you provide a sample data in excel&nbsp; and output expected?</P></BODY></HTML> Tue, 12 Aug 2014 12:16:52 GMT Anonymous 2014-08-12T12:16:52Z Write an aggr expression https://community.qlik.com/t5/QlikView/Write-an-aggr-expression/m-p/664616#M242008 <HTML><HEAD></HEAD><BODY><P>Hi guys!</P><P></P><P>I divided the weight in classes of 2 like this:</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">=Class(emptyings_adjusted_weight),2)</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Actually I need the sum of the weight, how do I write that?</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">I tried:</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">=Class(aggr(sum(emptyings_adjusted_weight)),2)</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Anyone else better ideas? <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Kind regards,</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Katleen<BR /></SPAN></P></BODY></HTML> Tue, 12 Aug 2014 11:44:20 GMT https://community.qlik.com/t5/QlikView/Write-an-aggr-expression/m-p/664616#M242008 2014-08-12T11:44:20Z Re: Write an aggr expression https://community.qlik.com/t5/QlikView/Write-an-aggr-expression/m-p/664617#M242009 <HTML><HEAD></HEAD><BODY><P>The aggr statement needs at least one dimension as the second parameter to provide the 'group by' context for the sum.</P><P></P><P>So it should be something like:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=Class(aggr(sum(emptyings_adjusted_weight),[Widget]),2)</SPAN></P></BODY></HTML> Tue, 12 Aug 2014 11:50:41 GMT https://community.qlik.com/t5/QlikView/Write-an-aggr-expression/m-p/664617#M242009 DavidFoster1 2014-08-12T11:50:41Z Re: Write an aggr expression https://community.qlik.com/t5/QlikView/Write-an-aggr-expression/m-p/664618#M242010 <HTML><HEAD></HEAD><BODY><P>Not sure about what you are searching but aggr needs the fields.</P><P></P><P>Aren't you searching something like <EM>=</EM><SPAN style="font-size: 10pt;"><EM>Class(sum(emptyings_adjusted_weight),2) </EM>?</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Regards</SPAN></P></BODY></HTML> Tue, 12 Aug 2014 11:54:58 GMT https://community.qlik.com/t5/QlikView/Write-an-aggr-expression/m-p/664618#M242010 rubenmarin 2014-08-12T11:54:58Z Re: Write an aggr expression https://community.qlik.com/t5/QlikView/Write-an-aggr-expression/m-p/664619#M242011 <HTML><HEAD></HEAD><BODY><P>Can you provide a sample data in excel&nbsp; and output expected?</P></BODY></HTML> Tue, 12 Aug 2014 12:16:52 GMT https://community.qlik.com/t5/QlikView/Write-an-aggr-expression/m-p/664619#M242011 Anonymous 2014-08-12T12:16:52Z