topic Re: Rolling annd YTD calculation in QlikView

Rolling annd YTD calculation

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

Hello,

I trying to calculate the rolling and ytd revenue for current and last year revenue, but not from the month of january to december. i need to do it from Sep 2017 to Aug 2018 and sep 2018 to Aug 2019.

='Current Year:'& Num(Sum({<[Trading Week End Date] = {">=$(=MakeDate(Year(Today()),9,1) )<=$(=MakeDate(Year(Today())+1,8,30) )"}> } NET_SLS_AMT/1000000),'##.00')
& ' Last Year:'&Num(Sum({<[Trading Week End Date] = {">=$(=MakeDate(Year(Today())-1,9,1) )<=$(=MakeDate(Year(Today()),8,30) )"}> } NET_SLS_AMT/1000000),'##.00')

I'm using this formula, but sales is reflecting from january to december. Can you please help me with this problem to get rolling & ytd sales from july month to june month

Thanks

Re: Rolling annd YTD calculation

Taoufiq_Zarra — Thu, 19 Dec 2019 17:10:17 GMT

here you compare [Trading Week End Date] which is a year with a full date?
Can we change [Trading Week End Date] by week?

Re: Rolling annd YTD calculation

Taoufiq_Zarra — Thu, 19 Dec 2019 17:13:59 GMT

Sep 2017 to Aug 2018 and sep 2018 to Aug 2019

Sep lasyear(2018) to Aug this year (2019) ?

Re: Rolling annd YTD calculation

saichawan — Fri, 20 Dec 2019 16:06:55 GMT

sep 2017 to aug 2018 as last year and sep 2018 to aug 2019 as current year