topic LAST YEAR CUMULATIVE in QlikView

LAST YEAR CUMULATIVE

sagaraperera — Tue, 22 Dec 2015 06:46:54 GMT

Dear all

Please note I have obtain the value of the last year month and the value of current year cumulative. Kindly advise me whether their is a method for an example by amalgamating the

Last Year Month = sum( {$<TRAN_YEAR = {"$(=Only([TRAN_YEAR]-1))"}>} [Actual])

Current Year Cumulative = sum( {<TRAN_MONTH={"<=$(=max(TRAN_MONTH))"}>} Actual)

and arrive at LAST YEAR CUMULATIVE

Sagara

Re: LAST YEAR CUMULATIVE

Chanty4u — Tue, 22 Dec 2015 06:52:22 GMT

hi,

https://community.qlik.com/docs/DOC-9162

hope this helps u

Re: LAST YEAR CUMULATIVE

tresB — Tue, 22 Dec 2015 06:52:42 GMT

Which time span are you interested of ?

Re: LAST YEAR CUMULATIVE

Tue, 22 Dec 2015 06:53:00 GMT

Try this link:

cumulative calulation for last year

Re: LAST YEAR CUMULATIVE

Chanty4u — Tue, 22 Dec 2015 06:54:27 GMT

sum( {$<TRAN_YEAR = {"$(=Max(Year([TRAN_YEAR]))-1)"}>} [Actual])