topic Row Subtotal & Total Aggregation in Lieu of Column Expression in QlikView https://community.qlik.com/t5/QlikView/Row-Subtotal-Total-Aggregation-in-Lieu-of-Column-Expression/m-p/760102#M1025770 <HTML><HEAD></HEAD><BODY><P>Hi all!&nbsp; I'm new here, and I'm hoping that someone has encountered the issue that I'm having.&nbsp; I have a report that I am building that will attribute gross margin impact to individual sales channels and products.&nbsp; I am breaking the types of margin impact between, price, cost, sales mix, and other.&nbsp; I have chosen to build the price calc first, which uses several other columns already on my report.&nbsp; I have successfully created the formula, which produces desired result at the bottom/children levels.&nbsp; However, my report has a total and several subtotals rows that are also calculating, but are completely wrong.&nbsp; This is expected, because the calc is only applicable at the input/child level.&nbsp; Rather, I want the total and subtotal rows in this columns aggregate the input level rows under them.&nbsp; How do I keep using the formula on the input level rows, but have the subtotals and total rows summarize the results of the input rows?</P></BODY></HTML> Fri, 06 Mar 2015 22:53:28 GMT 2015-03-06T22:53:28Z Row Subtotal & Total Aggregation in Lieu of Column Expression https://community.qlik.com/t5/QlikView/Row-Subtotal-Total-Aggregation-in-Lieu-of-Column-Expression/m-p/760102#M1025770 <HTML><HEAD></HEAD><BODY><P>Hi all!&nbsp; I'm new here, and I'm hoping that someone has encountered the issue that I'm having.&nbsp; I have a report that I am building that will attribute gross margin impact to individual sales channels and products.&nbsp; I am breaking the types of margin impact between, price, cost, sales mix, and other.&nbsp; I have chosen to build the price calc first, which uses several other columns already on my report.&nbsp; I have successfully created the formula, which produces desired result at the bottom/children levels.&nbsp; However, my report has a total and several subtotals rows that are also calculating, but are completely wrong.&nbsp; This is expected, because the calc is only applicable at the input/child level.&nbsp; Rather, I want the total and subtotal rows in this columns aggregate the input level rows under them.&nbsp; How do I keep using the formula on the input level rows, but have the subtotals and total rows summarize the results of the input rows?</P></BODY></HTML> Fri, 06 Mar 2015 22:53:28 GMT https://community.qlik.com/t5/QlikView/Row-Subtotal-Total-Aggregation-in-Lieu-of-Column-Expression/m-p/760102#M1025770 2015-03-06T22:53:28Z Re: Row Subtotal & Total Aggregation in Lieu of Column Expression https://community.qlik.com/t5/QlikView/Row-Subtotal-Total-Aggregation-in-Lieu-of-Column-Expression/m-p/760103#M1025771 <HTML><HEAD></HEAD><BODY><P>You can use "Chart Inter Record Functions" like Above() possibly also with the Advanced Aggregation function Aggr() Have a look in your QlikView help at these sections/chapters:</P><P></P><P>- Chart Inter Record Functions</P><P>- Advanced Aggregation</P><P>- Nested Aggregations and Related Issues</P><P></P><P>If you supply a sample app with some data on the calcs you have made so far maybe someone can make suggestions for actual solutions for you...</P></BODY></HTML> Sat, 07 Mar 2015 01:08:38 GMT https://community.qlik.com/t5/QlikView/Row-Subtotal-Total-Aggregation-in-Lieu-of-Column-Expression/m-p/760103#M1025771 petter 2015-03-07T01:08:38Z