Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i'm working on HR KI,
i need to calculate the turn over for stuff = (terminated / current active)*100
this should be for terminated employee with in a date Range
in my example if i need to get the turn over for Aug, i have one emp terminated.
where i have 12 active employee.
=Count({$ <EmpStatus={'Active'} >} DISTINCT EmpCode)
this is not working with me. any idea?
but u are using EmpStatus= {'Active'} in set analysis is that you mark terminated emplyee Active
just check correct field and see your database i am sure you will get your answer.
anant
I tried all below:
=Count({$ <EmpStatus={'Active'} >} DISTINCT EmpCode)
//=Count({$ +<TYPE={'H'} >} DISTINCT EmpCode)
//=Count ({$ +<EmpStatus={'Active'}, hiring_date ={"<=TerminationDate"}>} DISTINCT hiring_date)
//=Count({$ <TerminatedFlag={'Y'} >} DISTINCT TDate)
//=count ({< hiring_date {"=Aggr(hiring_date<=TerminationDate)"}>} DISTINCT EmpCode)
//=Count({$ <EmpStatus={'Active'}, hiring_date ={">=Date(TerminationDate)"} >} DISTINCT EmpCode)
i'm trying to use a date Range so i can get all active emplyee up to last date.
Hi Omar,
Can you please attach a qvw with sample data.
We'll surely sort out your problem.
Regards
Suresh Rawat
Hi
http://community.qlik.com/servlet/JiveServlet/downloadBody/5595-102-1-6820/HRMS_PreLoad%20(2).qvw
are you able to download the file?