https://community.qlik.com/t5/QlikView/Adding-a-constant-value-in-expression-and-full-accumulation/m-p/805039#M284204 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: arial,helvetica,sans-serif;">Hello Friends,</SPAN></P><P class="MsoNormal" style="margin: 0in 0in 0pt;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;">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.</SPAN></P><P class="MsoNormal" style="margin: 0in 0in 0pt;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;">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.</SPAN></P><P class="MsoNormal" style="margin: 0in 0in 0pt;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;"> </SPAN></P><P class="MsoNormal" style="margin: 0in 0in 0pt;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;">I am sure someone of you must have handled this kind of requirement. Is there any alternate way to implement this requirement?</SPAN></P><P><BR /> </P></BODY></HTML> Wed, 31 Dec 2014 08:48:46 GMT 2014-12-31T08:48:46Z https://community.qlik.com/t5/QlikView/Adding-a-constant-value-in-expression-and-full-accumulation/m-p/805039#M284204 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: arial,helvetica,sans-serif;">Hello Friends,</SPAN></P><P class="MsoNormal" style="margin: 0in 0in 0pt;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;">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.</SPAN></P><P class="MsoNormal" style="margin: 0in 0in 0pt;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;">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.</SPAN></P><P class="MsoNormal" style="margin: 0in 0in 0pt;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;"> </SPAN></P><P class="MsoNormal" style="margin: 0in 0in 0pt;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;">I am sure someone of you must have handled this kind of requirement. Is there any alternate way to implement this requirement?</SPAN></P><P><BR /> </P></BODY></HTML> Wed, 31 Dec 2014 08:48:46 GMT https://community.qlik.com/t5/QlikView/Adding-a-constant-value-in-expression-and-full-accumulation/m-p/805039#M284204 2014-12-31T08:48:46Z