topic Adding Calculated row in Straight table in QlikView https://community.qlik.com/t5/QlikView/Adding-Calculated-row-in-Straight-table/m-p/58874#M766757 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>I need to add a calculated row in my straight table based on the values of two different preceding row values.</P><P>like, for example,</P><P>I have the following table :</P><P></P><P><STRONG>Header&nbsp; </STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG> 2016</STRONG></P><P></P><P>operational cost&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30000</P><P>operational BL Count&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000</P><P><STRONG>Cost Per BL Count&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; #####&nbsp; (calculated row that I need to add : operational cost / operational BL count)</STRONG></P><P></P><P>Please Help ASAP.</P><P></P><P>Thanks.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Adding Calculated row in Straight table https://community.qlik.com/t5/QlikView/Adding-Calculated-row-in-Straight-table/m-p/58874#M766757 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>I need to add a calculated row in my straight table based on the values of two different preceding row values.</P><P>like, for example,</P><P>I have the following table :</P><P></P><P><STRONG>Header&nbsp; </STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG> 2016</STRONG></P><P></P><P>operational cost&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30000</P><P>operational BL Count&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000</P><P><STRONG>Cost Per BL Count&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; #####&nbsp; (calculated row that I need to add : operational cost / operational BL count)</STRONG></P><P></P><P>Please Help ASAP.</P><P></P><P>Thanks.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Adding-Calculated-row-in-Straight-table/m-p/58874#M766757 Anonymous 2020-11-25T16:16:04Z Re: Adding Calculated row in Straight table https://community.qlik.com/t5/QlikView/Adding-Calculated-row-in-Straight-table/m-p/58875#M766758 <HTML><HEAD></HEAD><BODY><P>Could you do that by doing a load on the base header items, then doing a concatenation from a RESIDENT load?</P><DIV> </DIV></BODY></HTML> Thu, 21 Jun 2018 15:15:49 GMT https://community.qlik.com/t5/QlikView/Adding-Calculated-row-in-Straight-table/m-p/58875#M766758 Anonymous 2018-06-21T15:15:49Z