Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

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
Highlighted

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()))