Discussion Board for collaboration on QlikView Scripting.
I need help on Coding Part.
See the Attachment.
Plz explain what you want
I want to calculate
If(RecNo()=1,MOB-Joining+Leaving,Peek(OpeningMOB)-Joining+Leaving) AS OpeningMOB
(RecNo()=1,MOB,Peek(OpeningMOB)) AS ClosingMOB
But I am not getting the result.
Can you let us know what you are trying to achieve.
Current I have found Current Month & Current Year Man On Board (MOB) in a Company and it is coming 998.
Out of this figure, I am applying logics to find the value of Man On Board (MOB) by using the formula
Man On Board (MOB)-Joining+Leaving for different Month & Years.
which is not working.