topic Re: How to calculate NetOpen? in QlikView https://community.qlik.com/t5/QlikView/How-to-calculate-NetOpen/m-p/1030779#M464687 <HTML><HEAD></HEAD><BODY><P>Hi Subba, can you provide more detail about what you are looking for?&nbsp; Maybe a qvw file sample?</P></BODY></HTML> Thu, 14 Apr 2016 05:37:56 GMT clondono 2016-04-14T05:37:56Z How to calculate NetOpen? https://community.qlik.com/t5/QlikView/How-to-calculate-NetOpen/m-p/1030777#M464685 <HTML><HEAD></HEAD><BODY><P>Hi Folks,</P><P></P><P>Any one help to calculate NetOpen.</P><P></P><P>Regards,</P><P>Subba Reddy.</P></BODY></HTML> Thu, 14 Apr 2016 05:25:53 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-NetOpen/m-p/1030777#M464685 2016-04-14T05:25:53Z Re: How to calculate NetOpen? https://community.qlik.com/t5/QlikView/How-to-calculate-NetOpen/m-p/1030778#M464686 <HTML><HEAD></HEAD><BODY><P>Please provide the sample data and also logic to calculate the Netopen</P></BODY></HTML> Thu, 14 Apr 2016 05:35:48 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-NetOpen/m-p/1030778#M464686 Kushal_Chawda 2016-04-14T05:35:48Z Re: How to calculate NetOpen? https://community.qlik.com/t5/QlikView/How-to-calculate-NetOpen/m-p/1030779#M464687 <HTML><HEAD></HEAD><BODY><P>Hi Subba, can you provide more detail about what you are looking for?&nbsp; Maybe a qvw file sample?</P></BODY></HTML> Thu, 14 Apr 2016 05:37:56 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-NetOpen/m-p/1030779#M464687 clondono 2016-04-14T05:37:56Z Re: How to calculate NetOpen? https://community.qlik.com/t5/QlikView/How-to-calculate-NetOpen/m-p/1030780#M464688 <HTML><HEAD></HEAD><BODY><P>you can refer this <A _jive_internal="true" href="https://community.qlik.com/message/5556#5556" title="https://community.qlik.com/message/5556#5556">https://community.qlik.com/message/5556#5556</A></P><P>like inventory we can calculate aging of customer , Instead of item consider customer and calculate</P><P>the outstanding like item stock and show the net balance.</P><P></P><P>HTH</P><P></P><P>Vikas</P></BODY></HTML> Thu, 14 Apr 2016 05:51:43 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-NetOpen/m-p/1030780#M464688 vikasmahajan 2016-04-14T05:51:43Z Re: How to calculate NetOpen? https://community.qlik.com/t5/QlikView/How-to-calculate-NetOpen/m-p/1030781#M464689 <HTML><HEAD></HEAD><BODY><P>Please find the sample data</P><P></P><P>NetOpen(Jan16)=Open(Jan16)+Open(Dec15)-Close(Jan16)</P></BODY></HTML> Thu, 14 Apr 2016 05:52:36 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-NetOpen/m-p/1030781#M464689 2016-04-14T05:52:36Z Re: How to calculate NetOpen? https://community.qlik.com/t5/QlikView/How-to-calculate-NetOpen/m-p/1030782#M464690 <HTML><HEAD></HEAD><BODY><P>may be this will help</P><P></P><P><A href="https://community.qlik.com/thread/41208">Help needed to get stock for Max day of Month</A></P></BODY></HTML> Thu, 14 Apr 2016 06:08:02 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-NetOpen/m-p/1030782#M464690 Kushal_Chawda 2016-04-14T06:08:02Z