Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Re: Inventory Level

Post your data or app.

Not applicable

Re: Inventory Level

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