topic Re: YTD Calculation in QlikView

YTD Calculation

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

Channels		Implemented
Channels		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 ?

Re: YTD Calculation

ali_hijazi — Mon, 12 Jun 2017 06:51:34 GMT

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)

Re: YTD Calculation

tyagishaila — Mon, 12 Jun 2017 07:34:43 GMT

Load *,

Rangesum(Count, Peek(YTD)) as YTD

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

Re: YTD Calculation

sunny_talwar — Mon, 12 Jun 2017 11:34:09 GMT

There are two ways you can approach this

1) use The As-Of Table

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