topic Re: accumulation of data in QlikView

accumulation of data

Mon, 06 Jan 2014 23:32:31 GMT

Hello cumunidad

any comment is vienvenido and thanks in advance

I just need to build the "MORTALITY" field into a new field "MORTAcum"

from the scrip. and perform many tests and I get what I need.

	IF( EDAD = PREVIOUS(EDAD) AND CVENUC = PREVIOUS(CVENUC),
	MORTALIDAD + PEEK(MORTAcum),
	MORTALIDAD)
	AS MORTAcum

note: note that "CVENUC" are groups

regards

Re: accumulation of data

vikasmahajan — Tue, 07 Jan 2014 04:11:54 GMT

Range Sum Command can use to achieve the same. Please see the your o/p in attached qvw.

Vikas

Re: accumulation of data

er_mohit — Tue, 07 Jan 2014 04:27:29 GMT

Try this

on expression side

rangesum(above(sum(MORTALIDAD),0,RowNo(Total)))

Re: accumulation of data

Tue, 07 Jan 2014 13:55:25 GMT

hello

appreciate your help are just suggestions for set-analysis and I need it from the scrip

Re: accumulation of data

Tue, 07 Jan 2014 14:12:36 GMT

Try Like below in the script:

LOAD * , IF(Previous(CVENUC)=CVENUC , MORTALIDAD+Peek(ACCUMORT) , MORTALIDAD) AS ACCUMORT INLINE [

CVENUC , EDAD ,MORTALIDAD

N001, 1, 0.15

N001, 2, 0.15

N001, 3, 0.15

N002, 1, 0.13

N002, 2, 0.13

N002, 3, 0.13

] ;

If the MORTLIDAD is always same and EDAD is counter, you can create the ACCUMORT by : EDAD*MORTLIDAD AS ACCUMORT