Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

looking for an expression for cumulative summation in the column

Dear Friends

I need an expression for generating the following table

SlNoPEIPEI
Cumulative
1100100
2200300
3500800
4-300500
5400900
66001500
72001700
81001800
93002100
105002600
11-6002000
123002300


I have the data for columns SlNo and PEI, I want to generate the PEI which holds the cumulative summations.

--

Satyajeet

3 Replies
edg_baltazar
Contributor

Re: looking for an expression for cumulative summation in the column

If you are using a Straight table , you can use the same expression of PEI but in te expression tab of the object properties check the 'Full Accumulation' option, regards!

Not applicable

Re: looking for an expression for cumulative summation in the column

Hi Edgar, Thank You for solving this problem.

Its working for straight table however the accumulation option is not availaible in case of pivot table.

I am interested to know if it can be done in Pivot table too.

Re: looking for an expression for cumulative summation in the column

Use Above function

like

RangeSum([PEI], Above(PEI Cumulative))

Celambarasan

Community Browser