Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

timpoismans
Contributor III

RangeSum(Above())

Hi all

I got the following problem:

I have a calculated value per week. Now I need to sum that value up per week,

RangeSum.PNG

So F is the calculated value. In the current week (noted by date of the Friday of that week), it has a value of 3. The week after, it has a value of 3 as well, but I want to see the sum of both, so 6. In the 3rd week, another 3 is calculated, so I want to see the total of 9.

I tried using the RangeSum(Above()) function, but it only takes the first week into account and doesn't add the following:

RangeSum(Above(Sum({<Date={"<=$(=$(vToDate))"}, DateType={'Forecast'}>}Forecastaantal),0,1000))

Any help is appreciated and thanks in advance!

Kind regards,

Tim P.

1 Solution

Accepted Solutions
MVP
MVP

Re: RangeSum(Above())

Since this is a pivot table, try with Before/After instead of Above/Below

RangeSum(Before(Sum({<Date = {"<=$(=$(vToDate))"}, DateType = {'Forecast'}>} Forecastaantal), 0, 1000))

2 Replies
MVP
MVP

Re: RangeSum(Above())

Since this is a pivot table, try with Before/After instead of Above/Below

RangeSum(Before(Sum({<Date = {"<=$(=$(vToDate))"}, DateType = {'Forecast'}>} Forecastaantal), 0, 1000))

timpoismans
Contributor III

Re: RangeSum(Above())

Thanks again, Sunny!

I keep learning more and more from you!