topic Creating chart for accumulation data in QlikView

Creating chart for accumulation data

Tue, 01 Dec 2015 01:46:12 GMT

I have a problem in creating a chart for cumulative graph.

For example,

In this graph, the cumulative sum go to the end because I using the function

rangesum(above(sum(Incurred),0,rowno())

But I want the graph to look like this in the example below,

In this graph, I use the function if() and create a new field as the maximum month for each year.

if( Month>MaxMonth2012 OR IsNull(Month) ,0 , rangesum( above ( sum( Incurred ) , 0 , MaxMonth2012 +1)))

This result in many extra field created for each year and take a long time to run.This is just data for the 2012 onwards, this could be more and more messy and time consuming if I take in the data from 2000 onwards.

Is there any other possible way to do this and make this easier?

Thank you very much for your help!

Re: Creating chart for accumulation data

anlonghi2 — Tue, 01 Dec 2015 17:12:30 GMT

Hi Kenth,

try setting Full accumulation option to your expression:

Chart Properties->Expressions
select Full accumulation from Accumulation options

best regards

Andrea

Re: Creating chart for accumulation data

Wed, 02 Dec 2015 01:09:11 GMT

This cannot works.

This will create the graph of the first example that all the line go to the end of the month since it is accumulation.

I want the graph to be like stop at the middle like in the second sample.

Re: Creating chart for accumulation data

anlonghi2 — Wed, 02 Dec 2015 10:34:44 GMT

hi Kenth,

could you provide sample data ?

Andrea