Solved: Re: PYTD vs YTD - Qlik Community

Nirpanthan · ‎2019-12-16

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

Anil_Babu_Samineni · ‎2019-12-16

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

Anil_Babu_Samineni · ‎2019-12-16

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful