topic Re: Calculating Sub-Total in a Straight Chart Table with Component in QlikView https://community.qlik.com/t5/QlikView/Calculating-Sub-Total-in-a-Straight-Chart-Table-with-Component/m-p/802906#M283473 <HTML><HEAD></HEAD><BODY><P>Thank you Clever.&nbsp; Much appreciated.</P><P></P><P>kind regards</P><P>Nayan</P></BODY></HTML> Fri, 16 Jan 2015 11:07:11 GMT 2015-01-16T11:07:11Z Calculating Sub-Total in a Straight Chart Table with Component https://community.qlik.com/t5/QlikView/Calculating-Sub-Total-in-a-Straight-Chart-Table-with-Component/m-p/802904#M283471 <HTML><HEAD></HEAD><BODY><P>Hi&nbsp; </P><P>I have a straight table with sub-totals , however I am stuggling to calculate the sub-totals for all the columns in the table</P><P>I have posted a similar discussion recently , but only this time each field is multiplied&nbsp; by a component quantity.</P><P></P><P>Please can you assist calculating the sub-total.</P><P></P><P>kind regards</P><P>Nayan</P></BODY></HTML> Fri, 16 Jan 2015 10:30:53 GMT https://community.qlik.com/t5/QlikView/Calculating-Sub-Total-in-a-Straight-Chart-Table-with-Component/m-p/802904#M283471 2015-01-16T10:30:53Z Re: Calculating Sub-Total in a Straight Chart Table with Component https://community.qlik.com/t5/QlikView/Calculating-Sub-Total-in-a-Straight-Chart-Table-with-Component/m-p/802905#M283472 <HTML><HEAD></HEAD><BODY><P>Please put your last parenthesis after Componet Qty for each expression</P><P></P><P>=SUM({&lt;[MonthIndex]={'$(vMaxMIMinus4)'}&gt;}[Sales Quantity]*[Component Qty])</P></BODY></HTML> Fri, 16 Jan 2015 10:37:12 GMT https://community.qlik.com/t5/QlikView/Calculating-Sub-Total-in-a-Straight-Chart-Table-with-Component/m-p/802905#M283472 Clever_Anjos 2015-01-16T10:37:12Z Re: Calculating Sub-Total in a Straight Chart Table with Component https://community.qlik.com/t5/QlikView/Calculating-Sub-Total-in-a-Straight-Chart-Table-with-Component/m-p/802906#M283473 <HTML><HEAD></HEAD><BODY><P>Thank you Clever.&nbsp; Much appreciated.</P><P></P><P>kind regards</P><P>Nayan</P></BODY></HTML> Fri, 16 Jan 2015 11:07:11 GMT https://community.qlik.com/t5/QlikView/Calculating-Sub-Total-in-a-Straight-Chart-Table-with-Component/m-p/802906#M283473 2015-01-16T11:07:11Z