Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
MZambo89
Contributor III
Contributor III

RangeSum of 2 different lines in a chart (Region)

Hi everyone,

Can I ask how I achieve the cumulative sum of each line below, they represent the 2 regions, South and Central?
I want the South figures to sum up in one line and the Central in another.

Ex. Central to be 4 + 1 + 12 + 6 etc those being Apr/May/June/July and the same for the South.
At the moment the RangeSum Sum Central and South together and I don't want that.


I can achieve this when I use one line only but it seems not to be working when I bring the Region Name in.

I posted a screenshot of the table with the count and range sum and how they are currently behaving.

The formula I used as "height of the line" is the following:

=RangeSum(Above(COUNT({<WORK_CODE={'HL','HDU','HUR'},CURRENT_FY={'Y'}>}DATA_UP_DT),0,RowNo()))

 

MZambo89_0-1663079954808.png

MZambo89_1-1663080018641.png

 

Labels (1)
0 Replies