Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT 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
galax_allu
Specialist
Specialist

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