https://community.qlik.com/t5/QlikView/Rangesum-issue/m-p/1860584#M1216117 <P>Hi,</P> <P>I'm using a Pivot Table Chart to accumulate a field value.</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="I1.jpg" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/66867i15D4C8306B42B5DB/image-size/large?v=v2&amp;px=999" role="button" title="I1.jpg" alt="I1.jpg" /></span></P> <P>ACTUAL field is calculate:</P> <P><EM>RangeSum(below(ACTUAL), $(vActual))</EM></P> <P>vActual field is the value of vActual variable:</P> <P><EM>$(vActual)</EM></P> <P>In this case the report works, but I must to transforn the report in Chart Straight table to be able to create an Excel using only some fields to send this Excel in Npriting.</P> <P>&nbsp;</P> <P>When I convert to Chart Straigt table, ACTUAL field doesn't calculate correctly.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="I2.jpg" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/66869i846657E0BCAF9BFD/image-size/large?v=v2&amp;px=999" role="button" title="I2.jpg" alt="I2.jpg" /></span></P> <P>&nbsp;</P> <P>Any idea?</P> <P>Thanks in advance.</P> <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/46628">@sunny_talwar</a>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 17 Nov 2021 16:39:11 GMT FCanseco 2021-11-17T16:39:11Z https://community.qlik.com/t5/QlikView/Rangesum-issue/m-p/1860584#M1216117 <P>Hi,</P> <P>I'm using a Pivot Table Chart to accumulate a field value.</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="I1.jpg" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/66867i15D4C8306B42B5DB/image-size/large?v=v2&amp;px=999" role="button" title="I1.jpg" alt="I1.jpg" /></span></P> <P>ACTUAL field is calculate:</P> <P><EM>RangeSum(below(ACTUAL), $(vActual))</EM></P> <P>vActual field is the value of vActual variable:</P> <P><EM>$(vActual)</EM></P> <P>In this case the report works, but I must to transforn the report in Chart Straight table to be able to create an Excel using only some fields to send this Excel in Npriting.</P> <P>&nbsp;</P> <P>When I convert to Chart Straigt table, ACTUAL field doesn't calculate correctly.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="I2.jpg" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/66869i846657E0BCAF9BFD/image-size/large?v=v2&amp;px=999" role="button" title="I2.jpg" alt="I2.jpg" /></span></P> <P>&nbsp;</P> <P>Any idea?</P> <P>Thanks in advance.</P> <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/46628">@sunny_talwar</a>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 17 Nov 2021 16:39:11 GMT https://community.qlik.com/t5/QlikView/Rangesum-issue/m-p/1860584#M1216117 FCanseco 2021-11-17T16:39:11Z