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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cumulative sum in Set Analysis

Hello!

I'm trying to discover
Set Analysis and I have a problem with a cumulative sum.

Here's the situation:

Dimensions:
1 / Article
2 /
Status

Expressions:

1/ Amount : Sum ({<Annee={$(=Max(Annee))}>} Amount)

2/ Cumulative Amout : rangesum(Above( (Sum ({<Annee={$(=Max(Annee))}>} Amount)),0,RowNo())) with the option total cumulation enable


Each change of status resets the cumulative sum to 0.

Could you help me?

Thank you

2 Replies
djallelsadki
Partner - Creator
Partner - Creator

Hello,

can you upload your qvw ?

Not applicable
Author

sorry i can't