Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
LoretaS
Contributor II
Contributor II

Line graph with two dimensions

Hi,

I have a table with cumulative sums per Vintage. (horizontally)

LoretaS_0-1741180304052.png

I need to create a line chart with cumulative sums, but the same formula with rangesum(before ()... ColumnNo() is not working. Does anybody know how to do it?

Here is graph on each month, but I need the same just with cumulative lines.

LoretaS_1-1741180437565.png

 

Labels (2)
1 Reply
JandreKillianRIC
Partner Ambassador
Partner Ambassador

Hi @LoretaS 

My result 

JandreKillianRIC_0-1741181651960.png

 

My Calculation 

Sum(Aggr(RangeSum(Above(Total Sum(Number), 0, Rowno())), Gender, Year))

 

Regards Jandre 

Mark the solution as accepted that solved your problem and if you found it useful, press the like button! Check out my YouTube Channel | Follow me on LinkedIn