topic Total with a calculated expression in QlikView https://community.qlik.com/t5/QlikView/Total-with-a-calculated-expression/m-p/1342222#M413367 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P>i created the simple table below, and i added a calculated dimension "%Calc" which is (Quantity Evolution)/(Quantity Advance).</P><P>i want only to have one total row for the "%Calc" dimension, since the "%Calc" inside the Brand Dimension doesn't make sense.</P><P>Anyone knows how to achive this?</P><P>Thank you</P><P></P><P><IMG alt="Table.PNG" class="jive-image image-1" height="86" src="https://community.qlik.com/legacyfs/online/166325_Table.PNG" style="height: 85.9355px; width: 720px;" width="720" /></P></BODY></HTML> Fri, 09 Jun 2017 09:00:48 GMT qlikviewaf 2017-06-09T09:00:48Z Total with a calculated expression https://community.qlik.com/t5/QlikView/Total-with-a-calculated-expression/m-p/1342222#M413367 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P>i created the simple table below, and i added a calculated dimension "%Calc" which is (Quantity Evolution)/(Quantity Advance).</P><P>i want only to have one total row for the "%Calc" dimension, since the "%Calc" inside the Brand Dimension doesn't make sense.</P><P>Anyone knows how to achive this?</P><P>Thank you</P><P></P><P><IMG alt="Table.PNG" class="jive-image image-1" height="86" src="https://community.qlik.com/legacyfs/online/166325_Table.PNG" style="height: 85.9355px; width: 720px;" width="720" /></P></BODY></HTML> Fri, 09 Jun 2017 09:00:48 GMT https://community.qlik.com/t5/QlikView/Total-with-a-calculated-expression/m-p/1342222#M413367 qlikviewaf 2017-06-09T09:00:48Z Re: Total with a calculated expression https://community.qlik.com/t5/QlikView/Total-with-a-calculated-expression/m-p/1342223#M413368 <HTML><HEAD></HEAD><BODY><P>No direct way to do this within QlikView, but there are some work around to do this. For example, see here:</P><P><A href="https://community.qlik.com/thread/240031">Pivot Table Partial Percentage</A></P></BODY></HTML> Fri, 09 Jun 2017 09:38:43 GMT https://community.qlik.com/t5/QlikView/Total-with-a-calculated-expression/m-p/1342223#M413368 sunny_talwar 2017-06-09T09:38:43Z