Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
matapp80
Contributor
Contributor

Cumultive sum considering two months ahead

Hi community,

I would like to understand how to make the cumultive sum considering two months ahead (as shown in the figure, column "Inc di compentenza entro 60gg"). Dimensions are YearMonth and Project. Any idea how to obtain that? thx!!!

 

YearMonthProjectSALLIncassato Inc di compentenza entro 60gg  Inc di compentenza entro 30gg 
20161117039970,000,00 0,000,0% 0,000,0%
20161217039970,000,00 0,000,0% 0,000,0%
20170217039970,000,00 0,000,0% 0,000,0%
20170317039970,000,00 3.000,000,0% 0,000,0%
20170417039970,000,00 7.000,000,0% 3.000,000,0%
201705170399711.820,003.000,00 9.000,0076,1% 7.000,0059,2%
20170617039970,004.000,00 9.000,000,0% 9.000,000,0%
20170717039970,002.000,00 9.000,000,0% 9.000,000,0%
20170817039970,000,00 10.000,000,0% 9.000,000,0%
20170917039970,000,00 10.000,000,0% 10.000,000,0%
20171017039970,001.000,00 10.000,000,0% 10.000,000,0%
20171117039970,000,00 10.000,000,0% 10.000,000,0%
20171217039970,000,00 10.000,000,0% 10.000,000,0%
20180217039970,000,00 10.000,000,0% 10.000,000,0%
20180317039970,000,00 10.000,000,0% 10.000,000,0%
20180417039970,000,00 10.000,000,0% 10.000,000,0%
20180517039970,000,00 10.000,000,0% 10.000,000,0%

 

Labels (1)
2 Replies
Edvin
Creator
Creator

Try:

=sum(aggr(rangesum(below(sum([Incassato]),2,1)),[Project])

matapp80
Contributor
Contributor
Author

it doesn't work... 😞