topic Re: Opening & closing stock in QlikView https://community.qlik.com/t5/QlikView/Opening-closing-stock/m-p/840612#M295425 <HTML><HEAD></HEAD><BODY><P>Hi. Could you please elaborate? how do u wish to calculate closing stock?</P></BODY></HTML> Sun, 07 Jun 2015 13:22:25 GMT 2015-06-07T13:22:25Z Opening & closing stock https://community.qlik.com/t5/QlikView/Opening-closing-stock/m-p/840610#M295423 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>How to calculate opening and closing<A class="vpulfmisxmf" href="#26805442" title="Click to Continue &gt; by ShopperamaIsDaBest"> stock<IMG src="https://cdncache-a.akamaihd.net/items/it/img/arrow-10x10.png" /></A> using following data.</P><P>Please find the attachment of input &amp; output excels.</P><P>Regards ,</P><P>Shweta Singh</P></BODY></HTML> Sun, 07 Jun 2015 11:06:07 GMT https://community.qlik.com/t5/QlikView/Opening-closing-stock/m-p/840610#M295423 2015-06-07T11:06:07Z Re: Opening & closing stock https://community.qlik.com/t5/QlikView/Opening-closing-stock/m-p/840611#M295424 <HTML><HEAD></HEAD><BODY><P>PFA of excels</P></BODY></HTML> Sun, 07 Jun 2015 11:09:47 GMT https://community.qlik.com/t5/QlikView/Opening-closing-stock/m-p/840611#M295424 2015-06-07T11:09:47Z Re: Opening & closing stock https://community.qlik.com/t5/QlikView/Opening-closing-stock/m-p/840612#M295425 <HTML><HEAD></HEAD><BODY><P>Hi. Could you please elaborate? how do u wish to calculate closing stock?</P></BODY></HTML> Sun, 07 Jun 2015 13:22:25 GMT https://community.qlik.com/t5/QlikView/Opening-closing-stock/m-p/840612#M295425 2015-06-07T13:22:25Z Re: Opening & closing stock https://community.qlik.com/t5/QlikView/Opening-closing-stock/m-p/840613#M295426 <HTML><HEAD></HEAD><BODY><P>no logic has been given by client</P></BODY></HTML> Sun, 07 Jun 2015 15:20:08 GMT https://community.qlik.com/t5/QlikView/Opening-closing-stock/m-p/840613#M295426 2015-06-07T15:20:08Z Re: Opening & closing stock https://community.qlik.com/t5/QlikView/Opening-closing-stock/m-p/840614#M295427 <HTML><HEAD></HEAD><BODY><P>how we can convert month from string format to&nbsp; num format</P></BODY></HTML> Sun, 07 Jun 2015 15:52:01 GMT https://community.qlik.com/t5/QlikView/Opening-closing-stock/m-p/840614#M295427 2015-06-07T15:52:01Z Re: Opening & closing stock https://community.qlik.com/t5/QlikView/Opening-closing-stock/m-p/840615#M295428 <HTML><HEAD></HEAD><BODY><P>any help</P></BODY></HTML> Mon, 08 Jun 2015 06:14:54 GMT https://community.qlik.com/t5/QlikView/Opening-closing-stock/m-p/840615#M295428 2015-06-08T06:14:54Z Re: Opening & closing stock https://community.qlik.com/t5/QlikView/Opening-closing-stock/m-p/840616#M295429 <HTML><HEAD></HEAD><BODY><P>I think you will need to get more information from your client on how to use these two spreadsheets.</P></BODY></HTML> Mon, 08 Jun 2015 06:21:30 GMT https://community.qlik.com/t5/QlikView/Opening-closing-stock/m-p/840616#M295429 jonathandienst 2015-06-08T06:21:30Z Re: Opening & closing stock https://community.qlik.com/t5/QlikView/Opening-closing-stock/m-p/840617#M295430 <HTML><HEAD></HEAD><BODY><P>This is how you can do it with a simple Straight Table approach. Create an expression for each column with a Set Expression which select the Year, Month and Data Type that should be retrieved for each column in the chart: (I have attached the sample application)</P><P></P><P><IMG alt="2015-06-08 #1.PNG" class="jive-image image-1" src="/legacyfs/online/88627_2015-06-08 #1.PNG" style="height: 332px; width: 620px;" /></P><P></P><P><IMG alt="2015-06-08 #3.PNG" class="jive-image image-2" src="/legacyfs/online/88631_2015-06-08 #3.PNG" style="height: 226px; width: 620px;" /></P><P></P><P><IMG alt="2015-06-08 #4.PNG" class="jive-image image-3" src="/legacyfs/online/88632_2015-06-08 #4.PNG" style="height: 338px; width: 620px;" /></P><P></P><P><IMG alt="2015-06-08 #2.PNG" class="image-4 jive-image" src="/legacyfs/online/88633_2015-06-08 #2.PNG" style="height: auto;" /></P></BODY></HTML> Mon, 08 Jun 2015 07:41:28 GMT https://community.qlik.com/t5/QlikView/Opening-closing-stock/m-p/840617#M295430 petter 2015-06-08T07:41:28Z