Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Accumulation question

Hello,

I want to create a chart that uses accumulation (I assume in some way).

This is what I want the outcome to look like:

DATE                   Total      Acc per month      Acc per year

2012 jan-01          100        100                       100

2012 jan-02          120        220                       220

2012 jan-03           80         300                       300

...

2012 jan-31          110        1300                      1300

2012 feb-01           90         90                         1390

2012 feb-02          130        220                        1610

...

I.e. for each month I want the accumulation to start from scratch.

But I want to display the indivudual dates in the month

When experimenting with the accumulation settings in the expression I can not get it to start from scratch each month.

Instead it just accumulates the number of steps back that I set.

Is this possible?

br

Martin

1 Solution

Accepted Solutions
MVP
MVP

Re: Accumulation question

Please see attached.

You need to create additional fields for Month (using Monthstart) and year, then you can create the expression for monthly accumulation like

=aggr( rangesum(above(Value,0, rowno())),Month,Date)

Hope this helps,

Stefan

1 Reply
MVP
MVP

Re: Accumulation question

Please see attached.

You need to create additional fields for Month (using Monthstart) and year, then you can create the expression for monthly accumulation like

=aggr( rangesum(above(Value,0, rowno())),Month,Date)

Hope this helps,

Stefan

Community Browser