https://community.qlik.com/t5/QlikView/Table-expression-ignoring-my-calculated-dimension/m-p/1536062#M439159 <P>Hello,&nbsp;</P><P>I&nbsp;have created a pivot table.</P><P>I would like to have in each column (1,2,3,4,5) the total sum of the values of the line.</P><P>It's not easy to explain, but I have create an app with comment which shoulg helps a lot.</P><P>Thank you for your help <span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2019-01-28_16h52_59.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/4635i97CC3499879F40BF/image-size/large?v=v2&amp;px=999" role="button" title="2019-01-28_16h52_59.png" alt="2019-01-28_16h52_59.png" /></span></P> Sat, 16 Nov 2024 04:38:24 GMT oxiofrt 2024-11-16T04:38:24Z https://community.qlik.com/t5/QlikView/Table-expression-ignoring-my-calculated-dimension/m-p/1536062#M439159 <P>Hello,&nbsp;</P><P>I&nbsp;have created a pivot table.</P><P>I would like to have in each column (1,2,3,4,5) the total sum of the values of the line.</P><P>It's not easy to explain, but I have create an app with comment which shoulg helps a lot.</P><P>Thank you for your help <span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2019-01-28_16h52_59.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/4635i97CC3499879F40BF/image-size/large?v=v2&amp;px=999" role="button" title="2019-01-28_16h52_59.png" alt="2019-01-28_16h52_59.png" /></span></P> Sat, 16 Nov 2024 04:38:24 GMT https://community.qlik.com/t5/QlikView/Table-expression-ignoring-my-calculated-dimension/m-p/1536062#M439159 oxiofrt 2024-11-16T04:38:24Z https://community.qlik.com/t5/QlikView/Table-expression-ignoring-my-calculated-dimension/m-p/1536073#M439161 <P>Try this</P><PRE>=Aggr(<FONT color="#FF0000">NODISTINCT</FONT> Sum( NB_DEPARTS_ENGINS * FL_SEUIL), SECTEUR)</PRE> Mon, 28 Jan 2019 16:10:55 GMT https://community.qlik.com/t5/QlikView/Table-expression-ignoring-my-calculated-dimension/m-p/1536073#M439161 sunny_talwar 2019-01-28T16:10:55Z https://community.qlik.com/t5/QlikView/Table-expression-ignoring-my-calculated-dimension/m-p/1536078#M439162 <P>Thank you so much for this fast and efficient solution !</P><P>Great <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Mon, 28 Jan 2019 16:13:18 GMT https://community.qlik.com/t5/QlikView/Table-expression-ignoring-my-calculated-dimension/m-p/1536078#M439162 oxiofrt 2019-01-28T16:13:18Z