Accumulation Problem

[#1]

Dear All,

I'm new in qlikview..In my qlikview accumulation option is disable in "Expression" TAB. How can i enable accumulaiton option.

Thanks,

Masba

[ashfaq_haseeb]

Hi,

Can you post sample application to look over.

Regards

ASHFAQ

[anbu1984 · Accepted solution]

Accumulation is not available in Pivot, Gauge chart etc. Which chart are you using?

[morgankejerhag]

Hi,

You can also achieve an aggregation by using the rangesum() function together with a inter record function such as above().

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

This will add upp all values from 0 to the current row.

In a pivot table it can quickly get tricky though depending on how you structure the pivot table.

[Gysbert_Wassenaar]

See this document for some alternatives: Calculating rolling n-period totals, averages or other aggregations

[#6]

Dear Anbu,

I'm using Pivot table... Thnx for ur reply...