If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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
Please help here to get it
=RangeSum(above(sum([Males Planted]),0,RowNo())) - above(RangeSum(above(sum([Males Planted]),0,RowNo())))
View solution in original post
What exactly are the expected values?
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