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

[Anonymous]

Sunny, you're my HERO.

But, one more question

Now in graph 2, when a code is in the same month in the same FactFaseActive, it does not show in chart.

It's expected to show the average of value of the two (in this case) codes that exists in that month in the same FactFaseActive.

Any thougths?

Sílvia

[sunny_talwar]

What is the expression you are using for the second chart?

[Anonymous]

First I've used the same as the first graph.

But I think it should be this one:

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

Right?

Because now my dimension is FactFaseActive.

But using this, the values are wrong, in that specific months it keeps showing the same value.

[sunny_talwar · Accepted solution]

Not sure, but may be this:

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

[Anonymous]

Yes, that works Sunny

Do you have any documentation, that explains cases like this, or the use of this functions together?

[sunny_talwar]

Unfortunately, I don't have any holy grail I can share with you. Most of this is through trial and error over the last 2-3 years.

[Anonymous]

So 2 more years through trial end error for me

Thanks a lot for your help Sunny.

I'll buy you a cup of coffe when you come to Portugal

Best Regards,

Sílvia

[sunny_talwar]

Hahahaha sounds like a plan