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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2014-12-31 03:48 AM

Adding a constant value in expression and full accumulation option to get teh umulative Sum

Hello Friends,

I want to create a chart to display head count growth by month across the selected calendar year. The data points are as on end of month. I will always have an opening head count at the start of the year. In this example it is 5.

While I am able to derive cumulative sum by “Count” expression and “Full Accumulation” option, I am unable to add the constant Opening Head Count across all values to reflect the actual head count over months. Let me know what I am missing in my expression.

I am sure someone of you must have handled this kind of requirement. Is there any alternate way to implement this requirement?


HeadCountExample.qvw
15 KB
749 Views
0 Likes
0 Replies