Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
rahulsingh12
New Contributor III

L3M Sum of Sales

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

2 Replies
prma7799
Honored Contributor III

Re: L3M Sum of Sales

Please check this

rolling last 3 months sales

Re: L3M Sum of Sales

What happens when you add an equal sign here

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