Rolling 12 MoM comparison

Tue, 05 Nov 2013 09:25:07 GMT

Hi,

I need a help on QoQ comparison of my Inventory numbers.

If I want to compare sales figure of my portfolio on MoM (Nov'13 vs. Nov'12) with rolling 12 months, I created following two expressions

Expression 1:

=Sum({$<YearMonth ={">=$(=Date(addmonths(Max(YearMonth), -11), 'MMM-YY')) <=$(=Date(addmonths(Max(YearMonth), 0), 'MMM-YY'))"}>} SALES)

Expression 2:

Sum({<YearMonth ={">=$(=Date(addmonths(Max(YearMonth), -23), 'MMM-YY')) <=$(=Date(addmonths(Max(YearMonth), -12), 'MMM-YY'))"}>} SALES)

This is giving correct comparison of MoM figures.

But to compare Inventory, I cant sum the numbers, I have to pick up sum of inventory no of a maximum week. Say for example, If I am tracking inventory for Oct'13, I will report only last week inventory.

Expression for Inventory :

Sum(if([Fiscal Week Ending]=Aggr(Nodistinct Max([Fiscal Week Ending]),[Year]),TOTAL_INV,0)

Now I want to compare these two things, showing MoM comparison of Invenory figures for rolling 12 months and Inventory would be subject to max week inventory.

I hope , I have able to explain this problem properly.

Any help would be greatly appreciated.

Thanks.

topic Rolling 12 MoM comparison in QlikView

Rolling 12 MoM comparison