Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
avastani
Partner - Creator III
Partner - Creator III

Weeks of Supply

New Bitmap Image.bmp

Hi,

Has anyone ever done a Weeks of Supply metric?

In my case, On Hand Inventory is reported Weekly by Product Hierarchy as is the Sales by Product Hierarchy and Customer Hierarchy.

I am looking to compute the Weeks of Supply metric which would be OnHand (Point in Time)/Sales Qty (by week)

However, I would like to do this on an aggregated Month-Year, Quarter-Year and Year levels which is not coming out accurately.

What I am really looking for is how to select the Max() data point for OnHand in a MonthYear or QUarterYear or Year as the time dimension.

For eg. in image above MonthYear- August 2013, the Onhand would be the value for the last week, in Sept2013 it woudl be the last week of that month, however, if the user cycles to WeekYear it would be the OnHand for that week. So when the pivot table collapses, weeks 22 OnHand would be for August 2013, week 27 for Sept 2013 as the month and so on.

0 Replies