topic Stock inventory cuurent Value in QlikView https://community.qlik.com/t5/QlikView/Stock-inventory-cuurent-Value/m-p/711409#M256210 <HTML><HEAD></HEAD><BODY><P>Hello folk,</P><P>i am having a following table</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 260px;"><TBODY><TR><TD height="20" width="64">itemcode</TD><TD width="64">qnty</TD><TD width="64">itemcost</TD><TD width="68">date</TD></TR><TR><TD align="right" height="20">1</TD><TD align="right">5</TD><TD align="right">10</TD><TD align="right" class="xl63">10/1/2014</TD></TR><TR><TD align="right" height="20">2</TD><TD align="right">10</TD><TD align="right"><STRONG>12</STRONG></TD><TD align="right" class="xl63">10/2/2014</TD></TR><TR><TD align="right" height="20">1</TD><TD align="right">5</TD><TD align="right">15</TD><TD align="right" class="xl63">10/3/2014</TD></TR><TR><TD align="right" height="20">1</TD><TD align="right">5</TD><TD align="right"><STRONG>18</STRONG></TD><TD align="right" class="xl63">10/4/2014</TD></TR></TBODY></TABLE><P></P><P>and i want to generate a following report</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="349"><TBODY><TR><TD height="20" width="64">itemcode</TD><TD width="64">qnty</TD><TD width="64">itemcost</TD><TD width="157">Current Inventory value</TD></TR><TR><TD align="right" height="20">1</TD><TD align="right">15</TD><TD align="right">18</TD><TD align="right">270</TD></TR><TR><TD align="right" height="20">2</TD><TD align="right">10</TD><TD align="right">12</TD><TD align="right">120</TD></TR></TBODY></TABLE><P></P><P>the report will take the cost of maximum of date for every itemcode and should calculate inventory stock according to that code.</P><P></P><P>Thanx</P></BODY></HTML> Sat, 27 Sep 2014 17:39:28 GMT bohravanraj 2014-09-27T17:39:28Z Stock inventory cuurent Value https://community.qlik.com/t5/QlikView/Stock-inventory-cuurent-Value/m-p/711409#M256210 <HTML><HEAD></HEAD><BODY><P>Hello folk,</P><P>i am having a following table</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 260px;"><TBODY><TR><TD height="20" width="64">itemcode</TD><TD width="64">qnty</TD><TD width="64">itemcost</TD><TD width="68">date</TD></TR><TR><TD align="right" height="20">1</TD><TD align="right">5</TD><TD align="right">10</TD><TD align="right" class="xl63">10/1/2014</TD></TR><TR><TD align="right" height="20">2</TD><TD align="right">10</TD><TD align="right"><STRONG>12</STRONG></TD><TD align="right" class="xl63">10/2/2014</TD></TR><TR><TD align="right" height="20">1</TD><TD align="right">5</TD><TD align="right">15</TD><TD align="right" class="xl63">10/3/2014</TD></TR><TR><TD align="right" height="20">1</TD><TD align="right">5</TD><TD align="right"><STRONG>18</STRONG></TD><TD align="right" class="xl63">10/4/2014</TD></TR></TBODY></TABLE><P></P><P>and i want to generate a following report</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="349"><TBODY><TR><TD height="20" width="64">itemcode</TD><TD width="64">qnty</TD><TD width="64">itemcost</TD><TD width="157">Current Inventory value</TD></TR><TR><TD align="right" height="20">1</TD><TD align="right">15</TD><TD align="right">18</TD><TD align="right">270</TD></TR><TR><TD align="right" height="20">2</TD><TD align="right">10</TD><TD align="right">12</TD><TD align="right">120</TD></TR></TBODY></TABLE><P></P><P>the report will take the cost of maximum of date for every itemcode and should calculate inventory stock according to that code.</P><P></P><P>Thanx</P></BODY></HTML> Sat, 27 Sep 2014 17:39:28 GMT https://community.qlik.com/t5/QlikView/Stock-inventory-cuurent-Value/m-p/711409#M256210 bohravanraj 2014-09-27T17:39:28Z Re: Stock inventory cuurent Value https://community.qlik.com/t5/QlikView/Stock-inventory-cuurent-Value/m-p/711410#M256211 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Current Inventory value</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P>FirstSortedValue(itemcost,-date) * sum(qnty)</P></BODY></HTML> Sat, 27 Sep 2014 18:17:23 GMT https://community.qlik.com/t5/QlikView/Stock-inventory-cuurent-Value/m-p/711410#M256211 maxgro 2014-09-27T18:17:23Z Re: Stock inventory cuurent Value https://community.qlik.com/t5/QlikView/Stock-inventory-cuurent-Value/m-p/711411#M256212 <HTML><HEAD></HEAD><BODY><P>Thanx Massimo Grossi <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 29 Sep 2014 08:39:24 GMT https://community.qlik.com/t5/QlikView/Stock-inventory-cuurent-Value/m-p/711411#M256212 bohravanraj 2014-09-29T08:39:24Z