Adding data

[Anonymous]

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

[undergrinder · Accepted solution]

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 )

The sorting order can make trouble.

G.

[Anonymous]

Thanks a lot sir!!

Regards

Deepanshu