Select a record with specific date in qlikview

[#1]

Hi Community,

     Can anyone tell me how to capture this data in the qlikview?

So i want to showing in the qlikview:

1. 22-Sep-2005 as Entry Date

2. 19-Nov-2009 as Leaving Date

Thanks.

Julius A

[tresesco]

Straight table:

Dimension: [Personnel no]

Entry Date (Exp): =Date(Min({<Status={Active}>}Start_BEGDA))

Leaving Date (Exp): =Date(Min({<Status={Inactive}>}Start_BEGDA))

[Chanty4u]

Min(Date) as entry date

Max(date) as leaving date?

[PrashantSangle]

Hi

Entry Date  =Date(Min({<Status={'Active'}>}[Start BEGDA]))

Leaving Date  =Date(Min({<Status={'Inactive'}>}[Start BEGDA]))

Regards