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

How do turn my line graph into a cumulative line graph?

The title says it all.

I can't see any options for this.

Is it a plugin that I need?

Thank you.

5 Replies
Anonymous
Not applicable
Author

Hi

Are you looking for

cumulative  Frequency Graph

or

cumulative  Graph

For any addition or increasing you can use

Expression...>Accumulation...>Full Accumulation

I am not sure of .

cumulative  Frequency Graph

Not applicable
Author

Thanks for your response Alluraiah.

I am using Qlik Sense Desktop and I don't see that option anywhere in the properties for the chart.

antoniotiman
Master III
Master III

Hi,

Expression

RangeSum(Above(Sum(Value),0,RowNo()))

Regards,

Antonio

Bonnie
Contributor
Contributor

What worked for me was including the TOTAL in the RowNo()  and count() so try using TOTAL

RangeSum(Above(TOTAL count({<M_STATUS=p(M_STATUS)>}DISTINCT [PM Number]),0,RowNo(TOTAL)))

Bonnie
Contributor
Contributor

Good short review on the subject 

 

https://www.youtube.com/watch?v=AlT_jAMsiGU