Discussion Board for collaboration on QlikView Layout & Visualizations.
I need an expression for generating the following table
I have the data for columns SlNo and PEI, I want to generate the PEI which holds the cumulative summations.
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!
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.
Use Above function
RangeSum([PEI], Above(PEI Cumulative))