https://community.qlik.com/t5/QlikView/TOTAL-OF-LINE/m-p/1707884#M724800 <P>Hello I have a TCD<BR />Family&nbsp; &nbsp; Subfamily&nbsp; &nbsp; Nature&nbsp; &nbsp;NP&nbsp; &nbsp; &nbsp;ED<BR />F1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;F11&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; X1&nbsp; &nbsp; &nbsp; &nbsp; 14&nbsp; &nbsp; &nbsp;24<BR />F2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;F21&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; X2&nbsp; &nbsp; &nbsp; &nbsp; 21&nbsp; &nbsp; &nbsp;22<BR />F3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;F31&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; X3&nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp;10</P><P>I would like to have the total of the lines on the right of the table. here is the result that I expect</P><P>Family&nbsp; &nbsp; &nbsp;Subfamily&nbsp; &nbsp; Nature&nbsp; &nbsp; NP&nbsp; &nbsp; ED&nbsp; &nbsp; Total<BR />F1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;F11&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;X1&nbsp; &nbsp; &nbsp; &nbsp; 14&nbsp; &nbsp; &nbsp; &nbsp;24&nbsp; &nbsp; &nbsp;38<BR />F2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;F21&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;X2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;21&nbsp; &nbsp; &nbsp; 22&nbsp; &nbsp; &nbsp;43<BR />F3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;F31&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;X3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp;20</P><P>Help please</P> Wed, 25 Nov 2020 16:16:04 GMT Ven6 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/TOTAL-OF-LINE/m-p/1707884#M724800 <P>Hello I have a TCD<BR />Family&nbsp; &nbsp; Subfamily&nbsp; &nbsp; Nature&nbsp; &nbsp;NP&nbsp; &nbsp; &nbsp;ED<BR />F1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;F11&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; X1&nbsp; &nbsp; &nbsp; &nbsp; 14&nbsp; &nbsp; &nbsp;24<BR />F2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;F21&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; X2&nbsp; &nbsp; &nbsp; &nbsp; 21&nbsp; &nbsp; &nbsp;22<BR />F3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;F31&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; X3&nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp;10</P><P>I would like to have the total of the lines on the right of the table. here is the result that I expect</P><P>Family&nbsp; &nbsp; &nbsp;Subfamily&nbsp; &nbsp; Nature&nbsp; &nbsp; NP&nbsp; &nbsp; ED&nbsp; &nbsp; Total<BR />F1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;F11&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;X1&nbsp; &nbsp; &nbsp; &nbsp; 14&nbsp; &nbsp; &nbsp; &nbsp;24&nbsp; &nbsp; &nbsp;38<BR />F2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;F21&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;X2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;21&nbsp; &nbsp; &nbsp; 22&nbsp; &nbsp; &nbsp;43<BR />F3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;F31&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;X3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp;20</P><P>Help please</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/TOTAL-OF-LINE/m-p/1707884#M724800 Ven6 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/TOTAL-OF-LINE/m-p/1707892#M724801 <P>several options, for example :</P><P>Dimension :Family, Subfamily, Nature</P><P>Meeasure 1(NP)=sum(NP)</P><P>Measure 2(ED)=sum(ED)</P><P>Measure 3(Total)=Column(1)+Column(2)</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Taoufiq_ZARRA_1-1591199844199.png"><img src="https://community.qlik.com/skins/images/F8B11FBB1963C3F5190A68D84129B237/responsive_peak/images/image_not_found.png" alt="Taoufiq_ZARRA_1-1591199844199.png" /></span></P><P>&nbsp;</P><P>attached qvw file</P><P>&nbsp;</P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P>&nbsp;</P> Wed, 03 Jun 2020 15:59:31 GMT https://community.qlik.com/t5/QlikView/TOTAL-OF-LINE/m-p/1707892#M724801 Taoufiq_Zarra 2020-06-03T15:59:31Z