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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Inventory Level

Hello now I have another question,

I wanted to Show the Aggregate stock for inventory.

But I have a Problem instead of having one product in stock I have 4 products products expressed in MatID.

So now what I want to have is the Level for each products in years. At first it would be helpful to Show the percentage of each product per year. And then look after the months. I have the months and years in separate columns.

Thanks in advance

2 Replies
robert_mika
Master III
Master III

Post your data or app.

Not applicable
Author

MANDT|MATNR|WERKS|LGORT|LFGJA|LFMON|LABST|UMLME|INSME|ENME|SPEME|RETME|VKLAB|VKUML

150|AB01218559|st01|BRE0|2012|4|5000.00||0|0|0|0|0|0

150|AB01218559|st03|EMM0|2012|4|40000.00||0|0|0|0|0|0

150|AB01218559|st04|RHE0|2012|4|270000.00||0|0|0|0|0|0

150|AB01218559|st02|GUN0|2012|4|24196.00||0|0|0|0|0|0

150|AB01218559|st05|BRO0|2012|4|.00||0|0|0|0|0|0

150|AB01218559|st02|GUN0|2012|5|300000.00||0|0|0|0|0|0

150|AB01218559|st05|BRO0|2012|5|626608.00||0|0|0|0|0|0

150|AB01218559|st05|BRO0|2012|6|750000.00||0|0|0|0|0|0

150|AB01218559|st05|BRO0|2012|10|.00||0|0|0|0|0|0

150|AB01218559|st02|GUN0|2012|10|.00||0|0|0|0|0|0

150|AB01218559|st04|RHE0|2012|10|104791.00||0|0|0|0|0|0

150|AB01218559|st03|EMM0|2012|10|40000.00||0|0|0|0|0|0

150|AB01218559|st01|BRE0|2012|10|5000.00||0|0|0|0|0|0

150|AB01218559|st04|RHE0|2012|11|.00||0|0|0|0|0|0

150|AB01218559|st03|EMM0|2012|11|.00||0|0|0|0|0|0

150|AB01218559|st01|BRE0|2012|11|.00||0|0|0|0|0|0

150|AB01218559|st01|BRE0|2013|4|5000.00||0|0|0|0|0|0