topic Re: rolling month comparison in QlikView

rolling month comparison

Wed, 12 Jun 2013 06:35:29 GMT

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 — Wed, 12 Jun 2013 06:48:55 GMT

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 — Wed, 12 Jun 2013 06:49:55 GMT

Hi Monica,

Go to these Links and threads they may help you out

Wed, 12 Jun 2013 08:52:57 GMT

i cant open qvw file..pls provide steps