Issue with getting the max(date) in set analysis

[#1]

Hi ,

I am developing an application, which shows the organization data . I am facing an issue trying to do this :

EmplId	TransferInDate	TransferOutDate
001	1-Jan-11	15-Jan-11
001	3-Feb-11	17-Feb-11
001	23-Feb-11	30-Feb-11

Can we get for this employee Max(TransferInDate)<=30-Feb-2011 and Max(TransferOutDate)<= 30-Feb-2011 , in set analysis. In this case I need to get the third record. I am not able to do Max([TransInDt]) < {"<=$(=MAX(Date here))"} in set analysis. Its giving me error when trying to write the expression.

Is it feasible to write an expression like this in QlikView  set analysis. For the selected period can we get max(TansInDt). Is there any other way to do this.

This is the expression I am using :

=Count(

            {

                         $<

                                     [Hire YearMonth] = {"<=$(=MAX(FullMonth))"},

                                     [HADYearMonth] = {"<=$(=Year(MAX(Date + 3)) * 10000 + Month(MAX(Date + 3)) * 100 + Day(MAX(Date + 3)))"}

                         >

                                                 -  <[no_accessed_project]={0},                                     //Upto here everything seems fine

                                                 Max([TransInYearMonth])={"<=$(=MAX(FullMonth))"}    //Getting an error here

                                                              >

            }

            distinct EmplId

)

Please suggest.

Thanks,

Srihari