Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Rolling 12 MoM comparison

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.

0 Replies