topic Straight Table - Expression Total in QlikView https://community.qlik.com/t5/QlikView/Straight-Table-Expression-Total/m-p/218489#M503318 <HTML><HEAD></HEAD><BODY><P>Is it possible to use Expression Total for one expression, Sum of Rows for the Total for a second expression and then use Sum of Rows total/ Expression total in a third expression?</P><P>For instance</P><P>Sum(Sales) - Expression 1 has expression total</P><P>Sum(Cost) - Expression 2 has expression total</P><P>FABS(Sum(Sales) - Sum(Cost)) has Sum of rows total</P><P>FABS(Sum(Sales) - Sum(Cost))/Sum(Sales) ===&gt; I want to do this but QV computes an incorrect total using Expression Total for everything.</P></BODY></HTML> Tue, 20 Apr 2010 02:08:14 GMT avastani 2010-04-20T02:08:14Z Straight Table - Expression Total https://community.qlik.com/t5/QlikView/Straight-Table-Expression-Total/m-p/218489#M503318 <HTML><HEAD></HEAD><BODY><P>Is it possible to use Expression Total for one expression, Sum of Rows for the Total for a second expression and then use Sum of Rows total/ Expression total in a third expression?</P><P>For instance</P><P>Sum(Sales) - Expression 1 has expression total</P><P>Sum(Cost) - Expression 2 has expression total</P><P>FABS(Sum(Sales) - Sum(Cost)) has Sum of rows total</P><P>FABS(Sum(Sales) - Sum(Cost))/Sum(Sales) ===&gt; I want to do this but QV computes an incorrect total using Expression Total for everything.</P></BODY></HTML> Tue, 20 Apr 2010 02:08:14 GMT https://community.qlik.com/t5/QlikView/Straight-Table-Expression-Total/m-p/218489#M503318 avastani 2010-04-20T02:08:14Z