Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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