Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

aveeeeeee7en
Valued Contributor III

Code Help Required

Hi Everyone

I need help on Coding Part.

See the Attachment.

Tags (1)
4 Replies
sujeetsingh
Honored Contributor III

Re: Code Help Required

Plz explain what you want

aveeeeeee7en
Valued Contributor III

Re: Code Help Required

I want to calculate

Opening MOB:

If(RecNo()=1,MOB-Joining+Leaving,Peek(OpeningMOB)-Joining+Leaving) AS OpeningMOB

Closing MOB:

(RecNo()=1,MOB,Peek(OpeningMOB)) AS ClosingMOB

But I am not getting the result.

vardhancse
Valued Contributor III

Re: Code Help Required

Can you let us know what you are trying to achieve.

aveeeeeee7en
Valued Contributor III

Re: Code Help Required

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.