Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Sidhu143B
New Contributor

Accumulation

Hi All,

Im new to qlikview, Want to understand how Accumulation will works, Please help me with the possibilities.

Attachment for your reference.

Thanks

 

2 Replies
Partner
Partner

Re: Accumulation

image.png'

In an accumulated chart, each y-value is added to the y-value of the following x-value.  By choosing full accumulation you will get the accumulated sum of all previous values in the expression, by choosing accumulate x steps back you only get the x-latest values added to your value. 

 

 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Support
Support

Re: Accumulation

From the Help:

By choosing between the settings in this group, you decide whether the values in the chart should be accumulated or not. In an accumulated chart, each y-value is added to the y-value of the following x-value. In an accumulated bar chart showing the sum of sales per year, e.g. the value of the year 1996 is added to that of the year 1997. If your chart contains several expressions, select the expression which values to be accumulated in the Expressions list. Accumulation is not available for pivot tables. 

No Accumulation 
If this option is selected, the y-values of the selected chart expression will not be accumulated.

Full Accumulation 
If this option is selected, each y-value will accumulate all previous y-values of the expression. See above under Accumulation. Full accumulation does not work for multiple dimensions containing Null or 0 values.

Note:Full accumulation does not work if the chart trellis is enabled.

Accumulate n Steps Back 
By entering a number in the box, you set the number of y-values in the expression to be accumulated. See above under Accumulation.

http://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Bar_Chart.htm

Regards,
Brett

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.