topic Re: set analysis for Date Range in QlikView

set analysis for Date Range

Tue, 31 Dec 2013 06:39:33 GMT

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?

Re: set analysis for Date Range

Anonymous — Tue, 31 Dec 2013 06:43:46 GMT

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

Re: set analysis for Date Range

Tue, 31 Dec 2013 06:46:44 GMT

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.

Re: set analysis for Date Range

suresh_rawat — Tue, 31 Dec 2013 06:55:42 GMT

Hi Omar,

Can you please attach a qvw with sample data.

We'll surely sort out your problem.

Regards

Suresh Rawat

Re: set analysis for Date Range

Tue, 31 Dec 2013 08:14:44 GMT

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

are you able to download the file?