topic Line Graph with two dimensions and accumulative values in QlikView

Line Graph with two dimensions and accumulative values

Anonymous — Fri, 14 May 2010 11:34:32 GMT

Hello,

I´m triying to make a line graph with dimensios MonthYEAR and a line with the accumulative value of the month and the year. For example we could have this kind of input data:

Year,MonthYEAR,Amount, Perecentage

2009, January2009, 10 , 5

2009, February2009, 20,4

2009, February2009, 30,6

2009, Marcha2009, 56,2

2009, April2009, 15,

2010, January2010, 20, 6

and we would like to have an line graph comparing this two expressions:

MonthYEAR, sum(Amount*Percentage)/sum(Amount) accumulated by month of the year

January2009, 5 --> (10x5/10)

February2009, 5,16 --> (10x5+20x4+30x6)/(10+20+30)

Marcha2009, 4--> (10x5+20x4+30x6+56x2)/(10+20+30+56)

April2009, 3,33 --> (10x5+20x4+30x6+56x2+15x1)/(10+20+30+56+15)

January2010, 6 --> (20x6)/20

Notice that in January 2010 the accumulative is restarted. With the help of this fastantic forum I made it in a simple table but if I tried to translate it to a graph, in January QV still calculates the accuumulative with 2009 values and do not restart the expression.

Thanks in advance,

Line Graph with two dimensions and accumulative values

Fri, 14 May 2010 11:58:02 GMT

Hi,
attached an example of how I would do it.
Calculate the 2 fields in the chart:

Field1: Amount * Percentage
Field2: accumulated sum of Amount

Don't show these fields in the chart and then have a third field/value where you do Field1/Field2.

I don't know how to reset the accumulation though.

Hope that helps a little.

Oliver

Line Graph with two dimensions and accumulative values

johnw — Fri, 14 May 2010 23:11:36 GMT

Here are both solutions from the previous thread, now expanded to include your new requirement.