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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Adding data

Hello All

Kindly help me in the below query of Qlik Sense.

I have months and cases. I want to use the cumulative function.

Can someone help me how to get the highlighted data in the attached sheet.

Please help

Thanks

Deepanshu

1 Solution

Accepted Solutions
undergrinder
Specialist II
Specialist II

Hi Deepanshu,

Try this at measure function:

=rangesum(above(TOTAL sum(Cases),0,rowno(TOTAL)))

(Stealed from this thread:

Cumulative linegraph with multiple dimensions

Thank you @Manish )

2016-05-09 21_46_21-Qlik Sense Desktop.png

The sorting order can make trouble.

G.

View solution in original post

2 Replies
undergrinder
Specialist II
Specialist II

Hi Deepanshu,

Try this at measure function:

=rangesum(above(TOTAL sum(Cases),0,rowno(TOTAL)))

(Stealed from this thread:

Cumulative linegraph with multiple dimensions

Thank you @Manish )

2016-05-09 21_46_21-Qlik Sense Desktop.png

The sorting order can make trouble.

G.

Anonymous
Not applicable
Author

Thanks a lot sir!!

Regards

Deepanshu