Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Range Sum above based on specific group issue

I have requirement to get the values

MonthSalesGroup#Sales
Jan 2010SYA1
Jan 2010SYE185
Jan 2010SYM562
Feb 2010SYA1
Feb 2010SYE143
Feb 2010SYM571


expected results is Sales Group has to be accumulated to each group SYA for each period -shown values in the #Expected Results Column

MonthSalesGroup#Sales# Expected Results
Jan 2010SYA11
Jan 2010SYE185186
Jan 2010SYM562748
Feb 2010SYA12
Feb 2010SYE143328
Feb 2010SYM5711133


I tried

rangesum(above(count(distinct Sales),0,RowNo()))

I have option to select SalesGroup in the layout.

Advance Thanks for your help.

1 Reply
deepakk
Partner - Specialist III
Partner - Specialist III

HI,

I hope this application helps you out.