Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Thanks a lot sir!!
Regards
Deepanshu