topic Re: Rundown Line Chart - Accumulation Issue - RangeSum in QlikView https://community.qlik.com/t5/QlikView/Rundown-Line-Chart-Accumulation-Issue-RangeSum/m-p/96936#M15540 <HTML><HEAD></HEAD><BODY><P>Thank you very much for your assistance Sunny.</P><P></P><P>The only issue I found is if you have any logic on your dimensions such as using as Left or Date# etc. and even add this to the expression, it breaks. But its a easy fix by just moving the formatting to script <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> </P></BODY></HTML> Mon, 05 Nov 2018 10:31:10 GMT tyron_dougans 2018-11-05T10:31:10Z Rundown Line Chart - Accumulation Issue - RangeSum https://community.qlik.com/t5/QlikView/Rundown-Line-Chart-Accumulation-Issue-RangeSum/m-p/96934#M15538 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I currently have an issue with the Range Sum / Accumulation in QV when trying to use a line chart. I have attached an example to demonstrate. I am not sure how to get the accumulation to work as required.</P><P></P><P>In my Example, please note the following objects (Screenshot Below)</P><UL><LI>Table Box - Data Set - (Red) - Inline data loaded in script for test</LI><LI>Straight Table - (Green) - The line chart is following the straight tables logic on doing the rundown, which is incorrect. This has been highlighted in red</LI><LI>Un-Pivoted Table - (Blue) - This is to illustrate why the straight table is an issue and why the accumulation or range sum only works as needed when this table is pivoted. Result also highlighted in red</LI><LI>Pivot Table - (Blue) - This illustrates the outcome I need in table form and is correct. Result is highlighted in Green. But I need this to be applied to a graphic such as a line chart</LI><LI>Rundown Incorrect - (Line Chart) - This is the graphical version of what i need in the end, but unfortunately applies the straight table logic, which is incorrect</LI><LI>Rundown - (Text Object) - This is the end expected result</LI></UL><P></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/217199_Capture.PNG" style="height: 271px; width: 620px;" /></P><P></P><P>Thanks in advance </P><P></P><P>Regards</P><P>Tyron</P></BODY></HTML> Wed, 31 Oct 2018 14:02:04 GMT https://community.qlik.com/t5/QlikView/Rundown-Line-Chart-Accumulation-Issue-RangeSum/m-p/96934#M15538 tyron_dougans 2018-10-31T14:02:04Z Re: Rundown Line Chart - Accumulation Issue - RangeSum https://community.qlik.com/t5/QlikView/Rundown-Line-Chart-Accumulation-Issue-RangeSum/m-p/96935#M15539 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><STRONG>RangeSum(Sum(TOTAL &lt;TreatyYear&gt; Amount), -Aggr(RangeSum(Above(Sum(Amount), 1, RowNo())), TreatyYear, DateKey))</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/217289_Capture.PNG" style="height: 194px; width: 620px;" /></P></BODY></HTML> Thu, 01 Nov 2018 11:24:29 GMT https://community.qlik.com/t5/QlikView/Rundown-Line-Chart-Accumulation-Issue-RangeSum/m-p/96935#M15539 sunny_talwar 2018-11-01T11:24:29Z Re: Rundown Line Chart - Accumulation Issue - RangeSum https://community.qlik.com/t5/QlikView/Rundown-Line-Chart-Accumulation-Issue-RangeSum/m-p/96936#M15540 <HTML><HEAD></HEAD><BODY><P>Thank you very much for your assistance Sunny.</P><P></P><P>The only issue I found is if you have any logic on your dimensions such as using as Left or Date# etc. and even add this to the expression, it breaks. But its a easy fix by just moving the formatting to script <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> </P></BODY></HTML> Mon, 05 Nov 2018 10:31:10 GMT https://community.qlik.com/t5/QlikView/Rundown-Line-Chart-Accumulation-Issue-RangeSum/m-p/96936#M15540 tyron_dougans 2018-11-05T10:31:10Z