Announcements
Applications are open for the 2024 Qlik Luminary Program. Apply by December 15 here.
cancel
Showing results for
Did you mean:
Contributor II

## How to get Non Cumulative count

Hi ,

I have a pivot table

It is having Measure Males planted and for that i wanted to show cumulative count ---->RangeSum(above(sum([Males Planted]),0,RowNo()))

So, now i wanted to show non cumulative count by using cumulative count measure if i don't have Males Planted measure

Regards,

Buchannagari.

Labels (2)

• ### Visualization

1 Solution

Accepted Solutions
Champion III

use Above()

https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/InterRecor...

=RangeSum(above(sum([Males Planted]),0,RowNo())) - above(RangeSum(above(sum([Males Planted]),0,RowNo())))

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
4 Replies
Champion III

What exactly are the expected values?

for

Week9

Week10

Week11

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Contributor II
Author

Hi,

WEEK 09 is 0

WEEK 10 is 641.47[(WEEK 10-WEEK 09)]

WEEK 11 is 392.19[(WEEK 11 -WEEK 10)]

The measure' Males Planted' is having non cumulative count (This the output we want)

But here i don't want to use that Males Planted field from the data

By using 'Cumulative Males Planted Running Total' field we need to get that 'Males Planted' values

Buchannagari.

Champion III

use Above()

https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/InterRecor...

=RangeSum(above(sum([Males Planted]),0,RowNo())) - above(RangeSum(above(sum([Males Planted]),0,RowNo())))

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Contributor II
Author

Thank you...

Tags
Community Browser