Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

unable to display cumulative totals using rangesum

Hi All,

Please help what is wrong in the below rangesum expression. I am unable to display cumulative totals .

rangesum(above((Count({<[MASTER_CALENDER.Year]={'$(=$(VSelectYr))'},
[MASTER_CALENDER.Date]={"<$(=$(VSelectDate))"},[CASE.COUNT]={'1'}
CASE.CASE_ID)),0,rowno()))

1 Reply
sunny_talwar

Do you see anything with your expression? May be try this

RangeSum(Above(Count({<[MASTER_CALENDER.Year] = {'$(=$(VSelectYr))'}, [MASTER_CALENDER.Date] = {"<$(=$(VSelectDate))"}, [CASE.COUNT] = {'1'}>} CASE.CASE_ID), 0, RowNo()))