Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
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
Highlighted
Master III
Master III

Please check this

rolling last 3 months sales

Highlighted

What happens when you add an equal sign here

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