Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Partner
Partner

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

2 Replies
Highlighted
Partner
Partner

Re: cumulative sum for different values

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

Highlighted
Partner
Partner

Re: cumulative sum for different values

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