calculate Opening and closing Count

[pk]

Hello,

I Need help into calculate count of at the start of month and at the end of month,

am having HR data with me like

Empcode,

DOJ, Emp Left date,
Active/ Inactive Flag (if emp is working then it will be active else it will be Inactive)

Output should be like -
for april month opening count will be last year's March Month's closing count.
for may Month opening stock will be April Month's Closing stock ect..

Thanks in advance

[Sue_Macaluso]

@pk Hi, are you using QlikView or Sense? I would like to move this into the correct product forum. 

[pk]

am using qlikview

[Brett_Bleess]

Priti, I think for this one you are likely going to need to attach the QVW you have, or a sample that has your data model etc. in order for folks to suggest things.

Regards,
Brett