Qlik view - Column Accumulation

[Anonymous]

Hi guys,

See the above image:

I want to create an accumulation of Column Variation in Column Variation Accum.

I'm using the same expression for both columns, but in the last one I'm using the "Full Accumulation" that qlikview has, but it's not working.

Can you pease help

Thanks in advance,

Sílvia

[MK_QSL]

Use this...Change SUM(Amount) to your respective measure aggregation.

Num((RangeSum(Above(SUM(Amount),0,RowNo())) - Above(RangeSum(Above(SUM(Amount),0,RowNo()))))/Above(RangeSum(Above(SUM(Amount),0,RowNo()))),'#0.00%')

[Anonymous]

Hi,

I've attached a qvw sample.

Manish, still can't do it with your example.

Sílvia

[sunny_talwar]

What is the expected output from the sample you have provided?

[Anonymous]

Hi Sunny,

Iv'e attached a xls file, with a yellow column wich is my expected output.

I want for each code the accumulation of values in each month.

[sunny_talwar]

Try this

RangeSum(Above(TOTAL $(fVar(*)), 0, RowNo(TOTAL)))

[Anonymous]

Sunny,

It works for the first code,

When code changes, I to reset the accumulation.

I want the accumulation aggregated by code.

Is it possible?

Sílvia

[sunny_talwar]

Try this:

RangeSum(Above(TOTAL $(fVar(*)), 0, Aggr(RowNo(), Code, Month)))

[Anonymous]

Sunny,

Your expression works in table.

now, I want to put that in a line chart (see the attached)

When I only select a code it gives the right values, but when I show all codes, it does not.

Can you help?

[sunny_talwar]

May be this for the chart

Aggr(RangeSum(Above(TOTAL $(fVar(*)), 0, RowNo())), Code, MonthYear)