Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

How can I sum up the previous months of the current year?

Help!

How can I sum up the previous months of the current year?

Examples: sum all of January to April

Jan = 10

20 = Feb

Mar = 10

Apr 5 =

  I got back 45

How could I do this?

1 Reply
Niru
Contributor II

Re: How can I sum up the previous months of the current year?

Hi,

Full Accumulation

If this option is selected, each y-value will accumulate all previous y-values of the expression. See above under Accumulation.

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

Bar Chart-->Expression-->Full Accumulation

i hope it should help

/Niranjan

Community Browser