topic Stock Calculations in QlikView https://community.qlik.com/t5/QlikView/Stock-Calculations/m-p/196538#M56564 <HTML><HEAD></HEAD><BODY><P>1)Table1:</P><P>Tag Date Openingqty GRDate</P><P>AAA 21/11/2010 170 22/11/2010</P><P></P><P></P><P>2)Table 2:</P><P></P><P>Tag BillDate qty Price GRDate</P><P>AAA 11/11/2010 80 50 22/11/2010</P><P>AAA 10/11/2010 90 40 22/11/2010</P><P>AAA 09/11/2010 20 30 22/11/2010</P><BR /><BR /> <P></P><P>Query:</P><P>Based on above two tables i want to sum price based on latest bill date wise. As per the example total qty is 170 and this qty is satisfied from first two rows of 2nd table so no need to considered 3rd row from 2nd table.</P><P>I want final output as;</P><P>Tag qty Price GRDate</P><P>AAA sum(80+90) (50+40) 22/11/2010</P><P></P><P>Plz suggest the solution:</P><P></P><P></P><P>Thanks,</P><P>Krutarth</P><P></P><P></P><P></P><P></P></BODY></HTML> Mon, 22 Nov 2010 10:57:46 GMT 2010-11-22T10:57:46Z Stock Calculations https://community.qlik.com/t5/QlikView/Stock-Calculations/m-p/196538#M56564 <HTML><HEAD></HEAD><BODY><P>1)Table1:</P><P>Tag Date Openingqty GRDate</P><P>AAA 21/11/2010 170 22/11/2010</P><P></P><P></P><P>2)Table 2:</P><P></P><P>Tag BillDate qty Price GRDate</P><P>AAA 11/11/2010 80 50 22/11/2010</P><P>AAA 10/11/2010 90 40 22/11/2010</P><P>AAA 09/11/2010 20 30 22/11/2010</P><BR /><BR /> <P></P><P>Query:</P><P>Based on above two tables i want to sum price based on latest bill date wise. As per the example total qty is 170 and this qty is satisfied from first two rows of 2nd table so no need to considered 3rd row from 2nd table.</P><P>I want final output as;</P><P>Tag qty Price GRDate</P><P>AAA sum(80+90) (50+40) 22/11/2010</P><P></P><P>Plz suggest the solution:</P><P></P><P></P><P>Thanks,</P><P>Krutarth</P><P></P><P></P><P></P><P></P></BODY></HTML> Mon, 22 Nov 2010 10:57:46 GMT https://community.qlik.com/t5/QlikView/Stock-Calculations/m-p/196538#M56564 2010-11-22T10:57:46Z Stock Calculations https://community.qlik.com/t5/QlikView/Stock-Calculations/m-p/196539#M56565 <HTML><HEAD></HEAD><BODY><P>Krutarth,</P><P>See attached solution.</P><P>Regards,</P></BODY></HTML> Mon, 22 Nov 2010 20:06:44 GMT https://community.qlik.com/t5/QlikView/Stock-Calculations/m-p/196539#M56565 vgutkovsky 2010-11-22T20:06:44Z