topic Re: Subtotals when using an expression in QlikView https://community.qlik.com/t5/QlikView/Subtotals-when-using-an-expression/m-p/521790#M551691 <HTML><HEAD></HEAD><BODY><P>Hi Archie,</P><P></P><P>In "Expression" tab (properties), you can either check :</P><P>- total (which execute expression)</P><P>- average</P><P><IMG alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/48108_pastedImage_1.png" style="width: auto; height: auto;" /></P><P>best regards</P><P>Chris</P></BODY></HTML> Thu, 24 Oct 2013 15:32:38 GMT 2013-10-24T15:32:38Z Subtotals when using an expression https://community.qlik.com/t5/QlikView/Subtotals-when-using-an-expression/m-p/521788#M551689 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I seem to be having a problem with getting my subtotal to work for a calculated field in a straight table.</P><P></P><P>The calculated field is an average of full cost.</P><P></P><P>The subtotals is showing me the average of the full cost for all rows instead of the total.</P><P></P><P>Please see below settings on Presentation tab for this field and let me know if I missing anything.</P><P></P><P>Thanks for your help.</P><P></P><P>Archie</P><P></P><P><IMG __jive_id="48100" alt="Subtotals for Average(Full Cost).PNG.png" class="jive-image" src="/legacyfs/online/48100_Subtotals for Average(Full Cost).PNG.png" style="width: 620px; height: 548px;" /></P></BODY></HTML> Thu, 24 Oct 2013 15:09:58 GMT https://community.qlik.com/t5/QlikView/Subtotals-when-using-an-expression/m-p/521788#M551689 2013-10-24T15:09:58Z Re: Subtotals when using an expression https://community.qlik.com/t5/QlikView/Subtotals-when-using-an-expression/m-p/521789#M551690 <HTML><HEAD></HEAD><BODY><P>Try this: Full Cost / sum(TOTAL Full Cost)&nbsp; This will be Average column.</P></BODY></HTML> Thu, 24 Oct 2013 15:15:09 GMT https://community.qlik.com/t5/QlikView/Subtotals-when-using-an-expression/m-p/521789#M551690 wgonzalez 2013-10-24T15:15:09Z Re: Subtotals when using an expression https://community.qlik.com/t5/QlikView/Subtotals-when-using-an-expression/m-p/521790#M551691 <HTML><HEAD></HEAD><BODY><P>Hi Archie,</P><P></P><P>In "Expression" tab (properties), you can either check :</P><P>- total (which execute expression)</P><P>- average</P><P><IMG alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/48108_pastedImage_1.png" style="width: auto; height: auto;" /></P><P>best regards</P><P>Chris</P></BODY></HTML> Thu, 24 Oct 2013 15:32:38 GMT https://community.qlik.com/t5/QlikView/Subtotals-when-using-an-expression/m-p/521790#M551691 2013-10-24T15:32:38Z