rolling month comparison

[#1]

how to compare sale of selected time frame with last year's same time frame.

as well as rolling 12 month comparison with previous year's rolling 12 month

[prasad_dumbre]

You need to write set anlysis for getting your requirements done.
Few Examples :

Current Month=>

=sum({<CalendarYear={$(=max(CalendarYear))},CalendarMonth={$(=Month(Max(Date)))}>} Sales)

Last Year's Same Month=>

=Sum({<CalendarYear=, CalendarMonth=,Date={'>=$(=MonthStart(Max(Date), -12))<=$(=MonthEnd(Max(Date), -12))'}>} Sales)

Last Month=>

=sum({<CalendarYear={$(=max(CalendarYear))},CalendarMonth={$(=month(addmonths((max(Date)),-1)))}>}Sales)

[sujeetsingh]

Hi Monica,

Go to these Links and threads they may help you out

http://community.qlik.com/thread/73615

http://community.qlik.com/thread/48352

http://community.qlik.com/thread/29394

[#4]

i cant open qvw file..pls provide steps