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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
nwilliams
Contributor
Contributor

Compounded Expression in Line Chart

Hi,

I'm trying to create a line chart that has a compounded expression.  For example, I have the following data

Jan - 10

Feb - 9

Mar - 11

Apr - 15

May - 5

What I want to show in the chart are the following values

Jan - 10

Feb - 19

Mar = 30

Apr - 45

May - 50

So this will effectively create a line that always curves up.  Any ideas how this can be achieved?

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Enable the Full Accumulation option for the expression. Or use something like rangesum(above(sum(Value),0,rowno())) as expression.


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Enable the Full Accumulation option for the expression. Or use something like rangesum(above(sum(Value),0,rowno())) as expression.


talk is cheap, supply exceeds demand
buzzy996
Master II
Master II

use this,

fullacc.PNG