How can we show opening and closing Head count MOM

[ajayagraa]

Hi All

In one of the requirement I have to show opening and closing emp headcount on month on month basis in my dashboard . also I have to develop the water fall chart to show the current Month and current year opening and closing Emp headcount with hiring and leaving of that month . am using master calendar and on selection of that the chart will filter out accordingly .  formula to calculate the opening and closing are given below

Opening balance = closing of the last month

Hiring = Current month joining

Leaving = Current month Leaving

Closing - Opening + Joining -leaving

can someone help me to achieve this requirement

Month	Opening Balance	Hiring	Leaving	Closing
Apr-17	1234	10	5	1239
May-17	1239	5	4	1240
Jun-17	1240	20	10	1250
Jul-17	1250	25	4	1271
Aug-17	1271	20	10	1281
Sep-17	1281	10	10	1281
Oct-17	1281	40	20	1301
Nov-17	1301	10	5	1306
Dec-17	1306	25	8	1323
Jan-18	1323	32	12	1343
Feb-18	1343	12	6	1349
Mar-18	1349	28	20	1357
Apr-18	1357	5	20	1342
May-18	1342	9	5	1346
Jun-18	1346	0	0	1346

Attaches file have content below things EIN - Employee Code Flag Sal - for Active emp along with new status 'Active' Left - Leaving Joining - for New joining

Sorry use this data

[ajayagraa]

are you checking ?

[sunny_talwar]

Check now...

[ajayagraa]

this is working only normal year but not working financial year calendar . can we do something in script side ?

[sunny_talwar]

I don't see any field named Financial year in the sample file your provided . What do you expect me to do? Read your mind my friend to know what you might have and what you might want. Please provide all the details to get better help

Best,

Sunny

[ajayagraa]

sunny , could you please create a financial year and then test your code ?

[sunny_talwar]

Sorry, I cannot do your work. If you need help then please do your part and I will do mine. If you don't want to... then let's just hope someone else might be willing to help.

Best,

Sunny

[ajayagraa]

Thanks buddy for your great help . I will try to resolve the rest part at mt own .

Thanks again

Ajay Verma

[sunny_talwar]

No problem at all. Please close this thread when you have your answer.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny

[Kunal12164]

Is any way i do all the logic in scripting rather than frontend calculation to get a same output?

[PrashantSangle]

@Kunal12164 , to get more help, I suggest , create new post. 

Also provide some data to get more accurate answer. Without having knowledge of your data, it is difficult to answer on question. 

As per my experience, most of the time yes it possible to move front end logic in backend.

Regards,

Prashant Sangle