Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
are you checking ?
Check now...
this is working only normal year but not working financial year calendar . can we do something in script side ?
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
sunny , could you please create a financial year and then test your code ?
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
Thanks buddy for your great help . I will try to resolve the rest part at mt own .
Thanks again
Ajay Verma
No problem at all. Please close this thread when you have your answer.
Qlik Community Tip: Marking Replies as Correct or Helpful
Best,
Sunny
Is any way i do all the logic in scripting rather than frontend calculation to get a same output?
@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