Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
aneelfazwani
Partner - Contributor II
Partner - Contributor II

cumulative number in script

Dear Forum members,

I have projects and month wise data which I need to accumulate over time. So, for every project, March 2015 number should show cumulative sum till March 2015. I don't want to use rangesum because I want to apply a condition later which is that if the status of a project is 'Inactive', the whole cumulative number for that month for that project should be 0.

I am attaching sample data ... kindly help how can this be achieved within script.

0 Replies