Cumulative totals on Expression column prob

[Qlik__Vinodh]

HI All,

how to calculate Cumulative totals on Expression column.if have soluation pls reply me.

Year 

Year(dimension)	Month(dimension)	=Count( Distinct EmpIds)-(Expression)	Cumulative totals(Expected)
2000	all months  group(1-12)	4	4
2001	all months  group(1-12)	7	11
2002	all months  group(1-12)	2	13
2003	all months  group(1-12)	5	18

This is pivot table.for this i need CUMMULATIVE TOTALS ( EXPECTED ) . if any one knows the last column Expressions pls let me reply me .

Thanks,

c

[#2]

Hi,

This examples may guide you.

http://community.qlik.com/message/257612#257612

http://community.qlik.com/message/231387#231387

Regards,

Janzen

[er_mohit · Accepted solution]

use this expression:

rangesum(above(sum(ncount),0,RowNo()))

here ncount is field name.

hope it helps you

[#4]

hi

for cumulative total use it.

rangesum(above(sum(Amount), 0 , RowNo()))

hope it helps you