Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

aerfurt85
New Contributor

Cumulated Values in Bar Chart

Hello,

I have a problem with cumulated values.

(look into the QVW)

Have anybody an idea?

Thanks

Andy

4 Replies
Not applicable

Cumulated Values in Bar Chart

Hi there,

Try the following expression:

rangesum(sum(Qty),above(total column(1)))

Please see the attached file, with your solution.

Regards

aerfurt85
New Contributor

Cumulated Values in Bar Chart

Thank you!


Exactly what I needed. Big Smile

Things can be so simple ... if you know how! ;-)

aerfurt85
New Contributor

Cumulated Values in Bar Chart

I must correct my answer,

it was exactly what I needed! ;-)

Now, the bar chart have to be cumulated.

When I select "Jan-Mrz" and "2008,2009" and check the box "Full Accumulation", the result is what I'm looking for.

But, when I select "Mrz" & "2008,2009" the result must be the same! This Problem I solved.

My Problem is, when I select "Mrz,Apr,Mai" and "2008,2009", the first bar must be the sum of ("Jan, Feb, Mrz"), the second the sum of ("Jan, Feb, Mrz, Apr") and the third the sum of ("Jan, Feb, Mrz, Apr,Mai").

In my imagination, it seems like this:
(File attachment)

Have anyone an idea?

MVP
MVP

Cumulated Values in Bar Chart

Generate an AsOf table.

AsOfYear, AsOfMonth, Year, Month
2010, 10, 2010, 10
2010, 10, 2010, 9
...
2010, 10, 2009, 11
2010, 9, 2010, 9
2010, 9, 2010, 8
...
2010, 9, 2009, 11
etc.

Replace your chart dimensions with AsOfYear and AsOfMonth. Use sum(Qty) as the expression.

Community Browser