PYTD vs YTD

Nirpanthan — Sat, 16 Nov 2024 19:27:02 GMT

Hi experts,

kindly help me for PYTD in this scenario

=(Sum({<Periodname,Segment3={440},ToDate={">=$(vStartDate)<=$(vTillDate)"}>}Closingbalance)+
Sum({<Periodname,Segment3={470},ToDate={">=$(vStartDate)<=$(vTillDate)"}>}Closingbalance)+
Sum({<Periodname,Segment3={480},ToDate={">=$(vStartDate)<=$(vTillDate)"}>}Closingbalance))/vThousand

Re: PYTD vs YTD

Anil_Babu_Samineni — Mon, 16 Dec 2019 12:37:30 GMT

Try this

=(Sum({<Periodname,Segment3={440},ToDate={">=AddYears($(vStartDate), -1)<=AddYears($(vTillDate)"}>}Closingbalance)+
Sum({<Periodname,Segment3={470},ToDate={">=AddYears($(vStartDate), -1)<=AddYears($(vTillDate), -1)"}>}Closingbalance)+Sum({<Periodname,Segment3={480},ToDate={">=AddYears($(vStartDate), -1)<=AddYears($(vTillDate), -1)"}>}Closingbalance)) /vThousand

topic PYTD vs YTD in QlikView

PYTD vs YTD

Re: PYTD vs YTD