topic Re: Select a record with specific date in qlikview in QlikView

Select a record with specific date in qlikview

Fri, 26 Feb 2016 02:44:08 GMT

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

tresB — Fri, 26 Feb 2016 10:41:20 GMT

Straight table:

Dimension: [Personnel no]

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

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

Chanty4u — Fri, 26 Feb 2016 10:44:42 GMT

Min(Date) as entry date

Max(date) as leaving date?

PrashantSangle — Fri, 26 Feb 2016 10:54:18 GMT

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

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

Regards