Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
c_pannese
Partner - Creator
Partner - Creator

cumulative sum for different values

proddateggCumulative sum for product
A12/01/201010
A15/02/202030
B18/01/2055
C1/01/2055
C3/03/201217

 

How can i obtain the cumulative sum for each product like the column ?

thanks

Labels (2)
2 Replies
ashishkalia
Partner - Creator
Partner - Creator

Hi  @c_pannese,

You have to do it in the back-end.

Create a new field with using this formula:

If(prod = Previous(prod), (gg + Previous(gg)), gg)                    as CumulativeSum

*don't forget to put order by clause in where condition (Order By date, prod)

attached link for the similar issue: Similar Post 

Let me know if works.

Regards,
AK

c_pannese
Partner - Creator
Partner - Creator
Author

I can't because gg is a measure. In the script i don' t have this field,it is a variabile value.