YTD and rolling calculation

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

Hi,

I have the code below which calculates the current year rolling sales and lasy year rolling sales. i'm not able to do the same for ytd calculation in the same code. i have filter of view with option of (rolling and ytd). if select rolling from the filter i can sales in text object with current year rolling sales and last year rolling sales. I want the same to be calculated for YTD.

Attaching you the QVW file and aslo the code for rolling calculation.

='Current Year:'& Num((Sum({<week = {">=$(vMinDate)<=$(vMaxdate)"}>} NET_SLS_AMT)/1000000),'##.00')
& ' Last Year:'&num((((Sum({<week = {">=$(vRollingStart)<=$(vRollingEnd)"},Period=>} NET_SLS_AMT)/1000000)
-
Sum({<week = {">=$(vRollingStart)<=$(vRollingEnd)"},Period= {'LYTD'}> } NET_SLS_AMT)/1000000)),'##.00')

Thanks

Re: YTD and rolling calculation

Anil_Babu_Samineni — Wed, 18 Dec 2019 12:55:51 GMT

What purposely you are creating many duplicate threads? Original Thread here and One More

Re: YTD and rolling calculation

sunny_talwar — Wed, 18 Dec 2019 12:59:36 GMT

Please look at my response to the other post

topic Re: YTD and rolling calculation in QlikView

YTD and rolling calculation

Re: YTD and rolling calculation

Re: YTD and rolling calculation