topic Aggr Function? in QlikView https://community.qlik.com/t5/QlikView/Aggr-Function/m-p/785785#M1052459 <HTML><HEAD></HEAD><BODY><P>h</P></BODY></HTML> Fri, 07 Nov 2014 03:54:57 GMT 2014-11-07T03:54:57Z Aggr Function? https://community.qlik.com/t5/QlikView/Aggr-Function/m-p/785785#M1052459 <HTML><HEAD></HEAD><BODY><P>h</P></BODY></HTML> Fri, 07 Nov 2014 03:54:57 GMT https://community.qlik.com/t5/QlikView/Aggr-Function/m-p/785785#M1052459 2014-11-07T03:54:57Z Re: Aggr Function? https://community.qlik.com/t5/QlikView/Aggr-Function/m-p/785786#M1052460 <HTML><HEAD></HEAD><BODY><P>Hello David,</P><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P>David Freschl wrote:</P> <P></P> <P>We should also be able to answer something like total per product. </P> </TD></TR></TBODY></TABLE></BLOCKQUOTE><P>For the above you try below expressions:</P><P></P><P>aggr(sum(BudgetAmount),BudgetProduct)</P><P></P><P>or to ignore the BudgetPerson Dimension</P><P>sum({&lt;BudgetPerson=&gt;}BudgetAmount)</P><P></P><P>Can you please attach a sample file with expected results.</P><P></P><P>Thanks,</P><P>Singh</P></BODY></HTML> Fri, 07 Nov 2014 04:04:09 GMT https://community.qlik.com/t5/QlikView/Aggr-Function/m-p/785786#M1052460 2014-11-07T04:04:09Z