Department %

[sunil-kumar5]

Hi Team,

I got the result on my table as I want per below however the issue is , I have a emp master table where I have joining date and leaving date. When I made selection by joining year or leaving year the count does not match. Is there anyone who can help please?

Department	Active Emp	Inactive Emp	Total Emp	Inactive%
HR	10	8	18	44.4
R&D	7	3	10	30.0
Sales	8	7	15	46.7
IT	4	2	6	33.3
Store	2	1	3	33.3
Accounts	5	5	10	50.0

Thanks

[dplr-rn · Accepted solution]

you need to elaborate a little but from a high level i would say your selections should not be on joining date/leaving date.

instead you should have a central date field for selections and use set analysis on joining/leaving date.

either use an island master calendar or try canonical date

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578