Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Accumalative Value

Hi All,

I have an issue, I have a straight table with 2 dimensions, DATE and PERIOD, there is a calculation on this table, and then I was to accumulate the calculation. the "full accumulation" option on the expressions tab is not working and all the calcs that I am trying either over add or simply bring back the line's result...please assist.

Current Formulae:

=Imbalance+RangeSum(above([Settlement Total]-[Stratus Total],0,RowNo()))

Thanks

5 Replies

Re: Accumalative Value

Do you want to Accumulate with both Dimensions?

Can you provide sample data?

Re: Accumalative Value

What is Imbalance here? That doesn't need to be fully accumulated?

Not applicable

Re: Accumalative Value

Hi there,

Yes I would assume that I would.

Regards

Not applicable

Re: Accumalative Value

Imbalance is the calculated feild

abhinav301
New Contributor

Re: Accumalative Value

Hi,

Can u provide sample data or qvw?

Community Browser