Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Buchannagari
Contributor II
Contributor II

How to get Non Cumulative count

Hi ,

I have a pivot table

Buchannagari_0-1654758426087.png

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

Please help here to get it

 

Regards,

Buchannagari.

 

Labels (2)
1 Solution

Accepted Solutions
vinieme12
Champion III
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.

View solution in original post

4 Replies
vinieme12
Champion III
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.
Buchannagari
Contributor II
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_0-1654768128133.png

 

Regrads,

Buchannagari.

 

vinieme12
Champion III
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.
Buchannagari
Contributor II
Contributor II
Author

Thank you...