topic Stock coverage next hours in QlikView https://community.qlik.com/t5/QlikView/Stock-coverage-next-hours/m-p/69600#M457977 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I have a little issue in order to calculate if the stock is covered or not for the next order(purchase).</P><P></P><P>In the Excel sheet attached.</P><P>Column A are the references.</P><P>Column B is the stock level</P><P>Column C are the next order (purchase) coming for the next 3 hours.</P><P>Column D should be my % of coverage.</P><P></P><P>I 'm lost in the calculation</P><P>the first expression is to sum the stock column&nbsp; B, the second to sum the next order column C.</P><P>the third expression in column D is to calculate the coverage pourcentage. This doen't work.</P><P></P><P>If my stock is higher than the order, I should see 100% because I'm cover.</P><P></P><P>My orders have a lead time of 4 hours. Nice to have if possible the coverage per hours <IMG src="https://community.qlik.com/legacyfs/online/emoticons/laugh.png" />.</P><P>the data with the hours received are in a different table (join in the discussion too)</P><P></P><P>thanks you so much</P><P>Regards</P><P>Fab</P></BODY></HTML> Fri, 22 Jun 2018 16:49:07 GMT Anonymous 2018-06-22T16:49:07Z Stock coverage next hours https://community.qlik.com/t5/QlikView/Stock-coverage-next-hours/m-p/69600#M457977 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I have a little issue in order to calculate if the stock is covered or not for the next order(purchase).</P><P></P><P>In the Excel sheet attached.</P><P>Column A are the references.</P><P>Column B is the stock level</P><P>Column C are the next order (purchase) coming for the next 3 hours.</P><P>Column D should be my % of coverage.</P><P></P><P>I 'm lost in the calculation</P><P>the first expression is to sum the stock column&nbsp; B, the second to sum the next order column C.</P><P>the third expression in column D is to calculate the coverage pourcentage. This doen't work.</P><P></P><P>If my stock is higher than the order, I should see 100% because I'm cover.</P><P></P><P>My orders have a lead time of 4 hours. Nice to have if possible the coverage per hours <IMG src="https://community.qlik.com/legacyfs/online/emoticons/laugh.png" />.</P><P>the data with the hours received are in a different table (join in the discussion too)</P><P></P><P>thanks you so much</P><P>Regards</P><P>Fab</P></BODY></HTML> Fri, 22 Jun 2018 16:49:07 GMT https://community.qlik.com/t5/QlikView/Stock-coverage-next-hours/m-p/69600#M457977 Anonymous 2018-06-22T16:49:07Z