Chart inventory range stock supply

Anonymous — Thu, 29 Oct 2015 17:44:28 GMT

Hi community

Was looking for a solution to display the range in months of our stocks.

Lets say i have an item with 50units and a monthly av. consumption of 10 units. i would like to aggregate the value of the stock, to month or quarter dimension on display this in bar chart.

I did check for a solution and found something, but the result is not what i want. In this sample the bar chart dimensions are 3M, 6M, 9M, 12M, 18M and over 18 months range. That’s actually ok from the dimension side. But the aggregation is not what i need. This solution will calculate the stock range in months (current inventory/avg. consumption) and add all the stock value to the same dimension value, in this case 6M. The result which i would like to have, is that the value of 30units will be added to 3M and the value of 20units to 6M. Even better it would be if i could use the calendar dimmension month-year, to display the values.

I made a test qvd, for better understanding.

Would be great if somebody could help me

Many thansk

topic Chart inventory range stock supply in QlikView

Chart inventory range stock supply