topic Re: Cumulative totals on Expression column prob in QlikView

Cumulative totals on Expression column prob

Qlik__Vinodh — Thu, 27 Dec 2012 07:20:13 GMT

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,

Thu, 27 Dec 2012 08:20:43 GMT

Hi,

This examples may guide you.

Regards,

Janzen

er_mohit — Thu, 27 Dec 2012 09:09:22 GMT

use this expression:

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

here ncount is field name.

hope it helps you

Thu, 27 Dec 2012 09:10:50 GMT

for cumulative total use it.

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

hope it helps you