set analysis for Date Range

[#1]

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?

[Anonymous]

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

[#3]

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.

[suresh_rawat]

Hi Omar,

Can you please attach a qvw with sample data.

We'll surely sort out your problem.

Regards

Suresh Rawat

[#5]

Hi

http://community.qlik.com/servlet/JiveServlet/downloadBody/5595-102-1-6820/HRMS_PreLoad%20(2).qvw

are you able to download the file?