topic Re: Code Help Required in QlikView https://community.qlik.com/t5/QlikView/Code-Help-Required/m-p/602921#M680057 <HTML><HEAD></HEAD><BODY><P>Current I have found Current Month &amp; Current Year Man On Board (MOB) in a Company and it is coming 998.</P><P></P><P>Out of this figure, I am applying logics to find the value of Man On Board (MOB) by using the formula</P><P>Man On Board (MOB)-Joining+Leaving&nbsp; for different Month &amp; Years.</P><P> which is not working.</P><P><BR /> </P></BODY></HTML> Tue, 22 Apr 2014 11:21:59 GMT aveeeeeee7en 2014-04-22T11:21:59Z Code Help Required https://community.qlik.com/t5/QlikView/Code-Help-Required/m-p/602917#M680053 <HTML><HEAD></HEAD><BODY><P>Hi Everyone</P><P></P><P>I need help on Coding Part.</P><P>See the Attachment.</P></BODY></HTML> Tue, 22 Apr 2014 09:01:37 GMT https://community.qlik.com/t5/QlikView/Code-Help-Required/m-p/602917#M680053 aveeeeeee7en 2014-04-22T09:01:37Z Re: Code Help Required https://community.qlik.com/t5/QlikView/Code-Help-Required/m-p/602918#M680054 <HTML><HEAD></HEAD><BODY><P>Plz explain what you want</P></BODY></HTML> Tue, 22 Apr 2014 11:01:32 GMT https://community.qlik.com/t5/QlikView/Code-Help-Required/m-p/602918#M680054 sujeetsingh 2014-04-22T11:01:32Z Re: Code Help Required https://community.qlik.com/t5/QlikView/Code-Help-Required/m-p/602919#M680055 <HTML><HEAD></HEAD><BODY><P>I want to calculate</P><P></P><P>Opening MOB:</P><P> </P><P><SPAN style="color: #0000ff; font-size: 8pt;">If</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">RecNo</SPAN><SPAN style="font-size: 8pt;">()=1,</SPAN><SPAN style="color: #800000; font-size: 8pt;">MOB</SPAN><SPAN style="font-size: 8pt;">-</SPAN><SPAN style="color: #800000; font-size: 8pt;">Joining</SPAN><SPAN style="font-size: 8pt;">+</SPAN><SPAN style="color: #800000; font-size: 8pt;">Leaving</SPAN><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Peek</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">OpeningMOB</SPAN><SPAN style="font-size: 8pt;">)-</SPAN><SPAN style="color: #800000; font-size: 8pt;">Joining</SPAN><SPAN style="font-size: 8pt;">+</SPAN><SPAN style="color: #800000; font-size: 8pt;">Leaving</SPAN><SPAN style="font-size: 8pt;">) </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">AS</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">OpeningMOB </SPAN></P><P> </P><P><SPAN style="color: #800000; font-size: 8pt;">Closing MOB:</SPAN></P><P><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">RecNo</SPAN><SPAN style="font-size: 8pt;">()=1,</SPAN><SPAN style="color: #800000; font-size: 8pt;">MOB</SPAN><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Peek</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">OpeningMOB</SPAN><SPAN style="font-size: 8pt;">)) </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">AS</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">ClosingMOB </SPAN></P><P> </P><P> </P><P><SPAN style="color: #800000; font-size: 8pt;">But I am not getting the result.</SPAN></P><P></P><P></P><P> </P><P></P></BODY></HTML> Tue, 22 Apr 2014 11:04:59 GMT https://community.qlik.com/t5/QlikView/Code-Help-Required/m-p/602919#M680055 aveeeeeee7en 2014-04-22T11:04:59Z Re: Code Help Required https://community.qlik.com/t5/QlikView/Code-Help-Required/m-p/602920#M680056 <HTML><HEAD></HEAD><BODY><P>Can you let us know what you are trying to achieve.</P></BODY></HTML> Tue, 22 Apr 2014 11:09:42 GMT https://community.qlik.com/t5/QlikView/Code-Help-Required/m-p/602920#M680056 vardhancse 2014-04-22T11:09:42Z Re: Code Help Required https://community.qlik.com/t5/QlikView/Code-Help-Required/m-p/602921#M680057 <HTML><HEAD></HEAD><BODY><P>Current I have found Current Month &amp; Current Year Man On Board (MOB) in a Company and it is coming 998.</P><P></P><P>Out of this figure, I am applying logics to find the value of Man On Board (MOB) by using the formula</P><P>Man On Board (MOB)-Joining+Leaving&nbsp; for different Month &amp; Years.</P><P> which is not working.</P><P><BR /> </P></BODY></HTML> Tue, 22 Apr 2014 11:21:59 GMT https://community.qlik.com/t5/QlikView/Code-Help-Required/m-p/602921#M680057 aveeeeeee7en 2014-04-22T11:21:59Z