Cumulative total

krish2459 — Sat, 16 Nov 2024 20:23:42 GMT

We need do an cumulative total.Please let me know how to get it.

Attached is the sample data.

Cumulative data required for the fields (Capacity in hours and demand )

Thanks..

Re: Cumulative total

kaushiknsolanki — Wed, 24 Jul 2019 08:26:16 GMT

Hi,

Check this link.

https://www.youtube.com/watch?v=AlT_jAMsiGU

Regards,

Kaushik Solanki

Re: Cumulative total

ramasaisaksoft — Wed, 24 Jul 2019 09:42:48 GMT

Hi Krish,

For a straight table object we have Options like below.So you can do Accumulation in Different manner in Expression Tab

we can split this accumulation for every 5 items also

Re: Cumulative total

Brett_Bleess — Mon, 19 Aug 2019 13:55:48 GMT

Just wanted to add the Help content for Full Accumulation:

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.

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.

If one of the other posts helped, be sure to give them credit by clicking Accept as Solution, or if you did something else, if you can post, you can mark that as the solution, so others can learn as well.

Check out the following as well, might be of some help too:

https://community.qlik.com/t5/Qlik-Design-Blog/Accumulations/ba-p/1466581

Regards,
Brett

topic Re: Cumulative total in QlikView

Cumulative total

Re: Cumulative total

Re: Cumulative total

Re: Cumulative total