Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
KNRaju105630
Partner - Contributor II
Partner - Contributor II

Cumulative sum

Hi Community,

I'm trying to calculate cumulative sum, normal cumulative working fine, but if it is same value above shouldn't be the sum.

Example:

LOAD * INLINE [
ID, ID1, Sales
IND00000361, IND00831134, 48.6
IND00000361, IND00006002, 25.11
IND00000361, IND00861752, 24.3
IND00489427, IND00000967, 20
IND00489427, IND00000969, 8
IND01070344, IND00268817, 43.74
IND00466207, IND00466207, 68.04
IND00000256, IND01084992, 31.59
IND00000256, IND00002505, 8.1
IND00000256, IND00005230, 3.24
IND00000256, IND00129462, 2.45
];

my output should be below screen.

KNRaju105630_0-1678703422554.png

PFA,

Labels (2)
3 Replies
KNRaju105630
Partner - Contributor II
Partner - Contributor II
Author

is there any possibility to achieve this ?

Please give suggestions 

paulwalker
Creator III
Creator III

I have a similar need, did you get solution for this ?

if anyone can provide a solution it would be helpful!

tresesco
MVP
MVP

If([Group Total]<>Above([Group Total]), RangeSum(Above(Total Cummulative), [Group Total]),Above(Total Cummulative))

tresesco_0-1679047580653.png