Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
rahulsingh12
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
prma7799
Master III
Master III

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]))