YTD Calculation

[Anonymous]

Hello All,

Channels		Implemented
		Count	YTD
2017	Jan	110	110
	Feb	107	217
	Mar	221	438
	Apr	194	632
	May
	Jun
	Jul
	Aug
	Sep
	Oct
	Nov
	Dec
	Total	632

I need to calculate the YTD column. Basically it is a summation of the count field, but it needs to be represented in a similar format in Qlikview. Any suggestions on the same ?

[ali_hijazi]

you need to do this in script

Load Year, Month, Count, if(rowNo() = 1 ,Count , Count + peek(YTD)) as YTD

order by Year, Month

then in your expression put sum(YTD)

[tyagishaila]

Load *,

Rangesum(Count, Peek(YTD)) as YTD

from ..............;

[sunny_talwar · Accepted solution]

There are two ways you can approach this

1) use The As-Of Table

2) Use RangeSum(Above(...)) function - >Accumulative Sums