Accumulated sums for year and month

[Anonymous]

Hi guys,

I have accumulated amounts per period but what I require is to be able to visualize it in a chart of lines analyzed for months and years, but when going to the chart at line type does not work as shown in the table chart. Please, someone can help me how to solve this problem?

For example for the period January 2016 my result in the point of the graph should be 137733 and not 20710 as it appears in the graph.

Thank you so much.

[aarkay29]

can you please post your expression used

[Anil_Babu_Samineni]

That's make sense only but it's tough to explain and solve

[Anonymous]

rangesum(above(total sum([Ctd.en UM entrada]),0, rowno(total)))

[jonathandienst]

if you are doing the accumulation in chart expression, it works according to the chart dimensions, so each dimension value (year) accumulates from the first entry (Jan).

You have not stated how you are doing the accumulation or the expression, but you may need a RangeSum(Above TOTAL....)) type expression to accumulate the way you want, or else do the accumulation in the load script.

[aarkay29]

Try this

Aggr(RangeSum(total Above(sum([Ctd.en UM entrada]), 0, RowNo())), Year, Month)

or

Aggr(RangeSum(total Above(sum([Ctd.en UM entrada]), 0, RowNo())), Year, (Month,(Numeric,Ascending))) this if you are using QLIKVIEW VERSION 12

[Anonymous]

Queries do not work

But in the following way if they work

But still the graph does not reflect what I need

[aarkay29]

Sorry try this

Aggr(RangeSum(Above(total sum([Ctd.en UM entrada]), 0, RowNo())), Year, (Month,(Numeric,Ascending)))

It will be in red but should be evaluating the expression

[Anonymous]

The same friend,

[Anonymous]

Hi jontydkpi,

I used this query:

rangesum(above(total sum([Ctd.en UM entrada]),0, rowno(total)))

But still the graph does not reflect what I need.

Now the problem is that the accumulated must be dynamic based on the filters they perform, which is why I do not think the script can be done.