https://community.qlik.com/t5/QlikView/Monthly-Stock-Expression-in-straight-table/m-p/1604744#M735954 <P>hey,&nbsp;</P><P>i need to create a straight table with each shop location and the monthly amount of stock that remains.&nbsp; i have the total amount [DEMAND_INV] that the stores require each month[MONTH] and the current inventory[AMOUNT].</P><P>e.g. july stock level needs to be 5</P><P>aug = 5</P><P>sept = 10</P><P>oct = 15</P><P>the current inv = 15, so therefore the store has 2.5 months of stock left. was wondering if anyone had any suggestions as to a good way of carrying out this calculation in QlikView.&nbsp; naturally i need this value to dynamically change as the months roll on.</P><P>any advice is highly appreciated&nbsp;</P> Sat, 16 Nov 2024 02:56:29 GMT anonymous1 2024-11-16T02:56:29Z https://community.qlik.com/t5/QlikView/Monthly-Stock-Expression-in-straight-table/m-p/1604744#M735954 <P>hey,&nbsp;</P><P>i need to create a straight table with each shop location and the monthly amount of stock that remains.&nbsp; i have the total amount [DEMAND_INV] that the stores require each month[MONTH] and the current inventory[AMOUNT].</P><P>e.g. july stock level needs to be 5</P><P>aug = 5</P><P>sept = 10</P><P>oct = 15</P><P>the current inv = 15, so therefore the store has 2.5 months of stock left. was wondering if anyone had any suggestions as to a good way of carrying out this calculation in QlikView.&nbsp; naturally i need this value to dynamically change as the months roll on.</P><P>any advice is highly appreciated&nbsp;</P> Sat, 16 Nov 2024 02:56:29 GMT https://community.qlik.com/t5/QlikView/Monthly-Stock-Expression-in-straight-table/m-p/1604744#M735954 anonymous1 2024-11-16T02:56:29Z