topic Cumulated Values in Bar Chart in QlikView

Cumulated Values in Bar Chart

aerfurt85 — Thu, 14 Oct 2010 15:35:20 GMT

Hello,

I have a problem with cumulated values.

(look into the QVW)

Have anybody an idea?

Thanks

Andy

Cumulated Values in Bar Chart

Thu, 14 Oct 2010 16:36:14 GMT

Hi there,

Try the following expression:

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

Please see the attached file, with your solution.

Regards

Cumulated Values in Bar Chart

aerfurt85 — Fri, 15 Oct 2010 09:32:46 GMT

Thank you!

Exactly what I needed.

Things can be so simple ... if you know how! 😉

Cumulated Values in Bar Chart

aerfurt85 — Fri, 29 Oct 2010 15:51:29 GMT

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?

Cumulated Values in Bar Chart

johnw — Fri, 29 Oct 2010 17:19:38 GMT

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.