topic Previous 12 months expression in QlikView

Previous 12 months expression

yvonne-c — Wed, 25 Nov 2020 16:16:04 GMT

I am using the following expression to calculate between two dates

Sum({<Date ={">=$(vStartDate)<=$(vEndDate)"}>} Price)

I also want to calculate the same period for the previous 12 months

I have tried the following expressions but cannot get them to work.

Sum({<Date={"=Date>=addmonths(vStartDate,-12) and Date<=addmonths(vEndDate,-12)"}>} Price)

Sum({$<Date ={">=$(=Num(AddMonths(vStartDate, -12)))<=$(=Num(AddMonths(vEndDate, -12)))"}>}Price)

Can anybody advise?

Thanks

sunny_talwar — Wed, 14 Jun 2017 16:07:52 GMT

What is the format of your date field? Also, are you making selection in Date or another date and time related fields?

sunny_talwar — Wed, 14 Jun 2017 16:08:44 GMT

May be try this

Sum({<Date={"=Only({1} Date) >= AddMonths(vStartDate, -12) and Only({1} Date) <= AddMonths(vEndDate, -12)"}>} Price)

yvonne-c — Thu, 15 Jun 2017 07:14:39 GMT

Thanks Sunny

This one seems to be working