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: 
dotnetfan
Contributor III
Contributor III

How to use RangeRum and Above

Hello Guys,

Now I'm working on a report, the requirement is to display aggr values for each month and week as following

 JulyJulyJulyJulyAugustAugustAugustAugust
Week Number2728293031323334
Actual Value12345678
Aggr value13595111826

 

Now I used following expression to display values but I don't know how to show it based on week and month:

RangeSum(Above(Sum("Actual Value",0,RowNo()))

 

Thanks!

Dotnetfan

 

4 Solutions

Accepted Solutions
sunny_talwar

May be you need this (if this is in a pivot table)

 

RangeSum(Before(Sum([Actual Value]), 0, ColumnNo()))

 

View solution in original post

Frank_Hartmann
Master II
Master II

missing ')'

RangeSum(Before(Sum([Actual Value]), 0, ColumnNo()))

View solution in original post

dotnetfan
Contributor III
Contributor III
Author

Resolve, thanks!!

Aggr(RangeSum(Above(Sum(Value), 0, RowNo())),"Month","Week")

View solution in original post

sunny_talwar

Seems to work okay... what is the issue in the attached screenshot?

image.png

View solution in original post

10 Replies
sunny_talwar

Is Week Number a dimension here too? How else are you making Month Repeat in the dimension?

sunny_talwar

May be you need this (if this is in a pivot table)

 

RangeSum(Before(Sum([Actual Value]), 0, ColumnNo()))

 

Frank_Hartmann
Master II
Master II

missing ')'

RangeSum(Before(Sum([Actual Value]), 0, ColumnNo()))

sunny_talwar

Yup, thanks for pointing that out
dotnetfan
Contributor III
Contributor III
Author

Hello, 

Here is the source data 

Column #1 is the month, #2 is week number, #3 is the expression and it looks doesn't work. Column #4 is the sum value and the last column is the expected output.

MonthWeekRangeSum(Above(Sum(Value), 0, RowNo()))SUM(Value)Expected
727325325325
728327327652
7293853851037
7304134131450
831299299299
833385385385
834365365365
835112711271127
936426426426
sunny_talwar

Is this resolved or are you still looking for help on this?

dotnetfan
Contributor III
Contributor III
Author

Not solved. Could you please help me with above data source? Really appreciated!

dotnetfan
Contributor III
Contributor III
Author

Resolve, thanks!!

Aggr(RangeSum(Above(Sum(Value), 0, RowNo())),"Month","Week")

sunny_talwar

Seems to work okay... what is the issue in the attached screenshot?

image.png