https://community.qlik.com/t5/App-Development/RangeSum-of-2-different-lines-in-a-chart-Region/m-p/1980503#M80918 <P>Hi everyone,<BR /><BR />Can I ask how I achieve the cumulative sum of each line below, they represent the 2 regions, South and Central?<BR />I want the South figures to sum up in one line and the Central in another.</P> <P>Ex. Central to be 4 + 1 + 12 + 6 etc those being Apr/May/June/July and the same for the South.<BR />At the moment the RangeSum Sum Central and South together and I don't want that.</P> <P><BR />I can achieve this when I use one line only but it seems not to be working when I bring the Region Name in.<BR /><BR />I posted a screenshot of the table with the count and range sum and how they are currently behaving.</P> <P>The formula I used as "height of the line" is the following:</P> <P>=RangeSum(Above(COUNT({&lt;WORK_CODE={'HL','HDU','HUR'},CURRENT_FY={'Y'}&gt;}DATA_UP_DT),0,RowNo()))</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MZambo89_0-1663079954808.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/89021iAFCCEFF64BB2BDDB/image-size/medium?v=v2&amp;px=400" role="button" title="MZambo89_0-1663079954808.png" alt="MZambo89_0-1663079954808.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MZambo89_1-1663080018641.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/89022i5751C7CEFB13D7AA/image-size/medium?v=v2&amp;px=400" role="button" title="MZambo89_1-1663080018641.png" alt="MZambo89_1-1663080018641.png" /></span></P> <P>&nbsp;</P> Tue, 13 Sep 2022 14:49:42 GMT MZqlik 2022-09-13T14:49:42Z https://community.qlik.com/t5/App-Development/RangeSum-of-2-different-lines-in-a-chart-Region/m-p/1980503#M80918 <P>Hi everyone,<BR /><BR />Can I ask how I achieve the cumulative sum of each line below, they represent the 2 regions, South and Central?<BR />I want the South figures to sum up in one line and the Central in another.</P> <P>Ex. Central to be 4 + 1 + 12 + 6 etc those being Apr/May/June/July and the same for the South.<BR />At the moment the RangeSum Sum Central and South together and I don't want that.</P> <P><BR />I can achieve this when I use one line only but it seems not to be working when I bring the Region Name in.<BR /><BR />I posted a screenshot of the table with the count and range sum and how they are currently behaving.</P> <P>The formula I used as "height of the line" is the following:</P> <P>=RangeSum(Above(COUNT({&lt;WORK_CODE={'HL','HDU','HUR'},CURRENT_FY={'Y'}&gt;}DATA_UP_DT),0,RowNo()))</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MZambo89_0-1663079954808.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/89021iAFCCEFF64BB2BDDB/image-size/medium?v=v2&amp;px=400" role="button" title="MZambo89_0-1663079954808.png" alt="MZambo89_0-1663079954808.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MZambo89_1-1663080018641.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/89022i5751C7CEFB13D7AA/image-size/medium?v=v2&amp;px=400" role="button" title="MZambo89_1-1663080018641.png" alt="MZambo89_1-1663080018641.png" /></span></P> <P>&nbsp;</P> Tue, 13 Sep 2022 14:49:42 GMT https://community.qlik.com/t5/App-Development/RangeSum-of-2-different-lines-in-a-chart-Region/m-p/1980503#M80918 MZqlik 2022-09-13T14:49:42Z