L3M Sum of Sales

[rahulsingh12]

Hi,

I have the following expression in qlikview.

round(sum({<Month=,Year={$(vPrevYear)},Description={'Actual'},MonthYear={">=$(=vLYL3MMonthYear)<=$(=vPrevMaxMonthYear)"}>}[Volume]))

Where vPrevYear= Max(Year)-1

vLYL3MMonthYear=(max(MonthYear)-100)-(2)

vPrevMaxMonthYear=max(MonthYear)-100

MonthYear = 201701,201702,201703......

Here i wanted the sum of volume for last 3 months for last year from current selected month

But I am getting YTD for this year.Don't know where is it going wrong?

Regards

[prma7799]

Please check this

rolling last 3 months sales

[sunny_talwar]

What happens when you add an equal sign here

Round(Sum({<Month, Year = {$(=vPrevYear)}, Description = {'Actual'}, MonthYear = {">=$(=vLYL3MMonthYear)<=$(=vPrevMaxMonthYear)"}>} [Volume]))