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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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