topic Re: Help required in the writing the below expression in QlikView

Help required in the writing the below expression

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

Let's assume Snapshot Date is "25/05/2019" so the below expression gives the sales of Mar,2019 to May,2019

Sum({<Date={'>=$(=MonthStart(Max([Snapshot Date]),-2))<=$(=Date(MonthEnd(Max([Snapshot Date]))))'}>}Sales)

What should be the change in the expression if I want to get the sales same as above months but for next year and previous year (i,e Mar,2020 to May,2020 and Mar,2018 to May,2018)

Please help...

Re: Help required in the writing the below expression

sasiparupudi1 — Thu, 04 Jul 2019 14:40:09 GMT

Use AddYears

to get last year

Sum({<Date={'>=$(=AddYears(MonthStart(Max([Snapshot Date]),-2),-1))<=$(=Date(AddYears(MonthEnd(Max([Snapshot Date])),-1)))'}>}Sales)

Next Year

Sum({<Date={'>=$(=AddYears(MonthStart(Max([Snapshot Date]),-2),1))<=$(=Date(AddYears(MonthEnd(Max([Snapshot Date])),1)))'}>}Sales)

Re: Help required in the writing the below expression

qlikviewforum — Fri, 05 Jul 2019 06:25:48 GMT

Thanks! Yes did that somehow forgot there is a function called AddYears.